Keep getting Ref# message with Vlookup
Hi Sojo,
You are asking to the second column but you just put one column (A2:A418) in
the range use A2:B418.
use =VLOOKUP(A2,'extracted names'!A2:B418,2,FALSE)
hth
regards from Brazil
Marcelo
"Sojo" escreveu:
Can some tell me what's wrong with my formula?
=VLOOKUP(A2,'extracted names'!A2:A418,2,FALSE)
I am trying to lookup A2 in another worksheet (extracted names) and want
excel to retun the corresponding value from another column column 2).
|