Keep getting Ref# message with Vlookup
 

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

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

Keep getting Ref# message with Vlookup
 

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