VLOOKUP

C

CLAUDIA

=IF(A3="",VLOOKUP(DATA,2,""))
I'm trying to pull information from a data source coulumn 2, but I keep
geting "false" can somebody tell me what I'm doing wrong! I haven't used for
long time and I totally forgot.

thanks
 
R

Roger Govier

Hi Claudia

You are not saying what you want to look up.
If it is the value in A3, then the formula should be
=IF(A3="","",VLOOKUP(A3,DATA,2))

If it is something else that you wish to lookup, provided that A3 is Null
then
=IF(A3="",VLOOKUP(somethingelse,DATA,2),"")
 
D

Dave Peterson

And if the OP is looking for an exact match:

=IF(A3="","",VLOOKUP(A3,DATA,2,False))
 
Top