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

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

Hi,

Look in help for #REF!.

Usual if you cut and move data or formula you get #REF!.

I'm getting the #N/A formula as not using Absolute's e.g $A$2:$A$418.

The attached link will helps with vlookups

http://www.contextures.com/xlFunctions02.html

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564425