MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### vlookup

• Follow

```i need a formula that will look up a word then give me the numbers in a cell
next to that word.  the formula i'm using (which isn't working right) is

=IF(ISERROR(VLOOKUP(A6,'Export
1'!\$B\$1:\$Z\$65467,11,FALSE)),"",VLOOKUP(A6,'Export 1'!\$B\$1:\$Z\$65467,11,FALSE))

this may be too much formula for what i need but i'm not sure...  here's
what i'm actually trying to do.  i would like to set up a check list or
something so when people select a certain row by adding a X, the following
information will auto fill onto another sheet...
```
 0

```Your vlookup looks ok. If its not returning 100% correct results, then it's
probably your data quality that's causing it, eg extraneous white spaces
throwing correct matching off. You could use TRIM to improve robustness,
something like this: =VLOOKUP(TRIM(A6), ....). Joy? hit the YES below
--
Max
Singapore
---
"dnmusic" wrote:
> i need a formula that will look up a word then give me the numbers in a cell
> next to that word.  the formula i'm using (which isn't working right) is
>
> =IF(ISERROR(VLOOKUP(A6,'Export
> 1'!\$B\$1:\$Z\$65467,11,FALSE)),"",VLOOKUP(A6,'Export 1'!\$B\$1:\$Z\$65467,11,FALSE))
>
> this may be too much formula for what i need but i'm not sure...  here's
> what i'm actually trying to do.  i would like to set up a check list or
> something so when people select a certain row by adding a X, the following
> information will auto fill onto another sheet...
```
 0

1 Replies
192 Views

Similiar Articles:

7/17/2012 8:28:50 AM