VLOOKUP

[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

 

[Joel]

I think this is what you want???

=IF(A3<>"",VLOOKUP(DATA,2),"")

 

[muddan madhu]

=if(a3="",vlookup(lookup_value,range,col_no,false),"")

 

[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),"")

 

[Dave Peterson]

And if the OP is looking for an exact match:

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