vlookup

D

dnmusic

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...
 
M

Max

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with an IF Formula 5
vlookup and using single quote 0
VLOOKUP & Data Validation 0
If, then, vlookup 1
Combobox 2
If equation with a VLookUp 3
combine three if functions 3
Vlookup 6

Top