Keep getting Ref# message with Vlookup

S

Sojo

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

Marcelo

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:
 
Top