If/Vlookup Statement

F

FrankB

Is there a way to combine an IF statement with a VLOOKUP
statement. Example:

=IF(a2<="TTW"),(VLOOKUP,TTW01,TTW,2)

Thanks
Frank
 
B

Bernard Liengme

=IF(A2<="TTW",VLOOPUP(lookup_value,loouup_table,column_number,true/false),""
)
Bernard
 
D

Dave Peterson

=if(a2<="ttw",vlookup(a2,yourlookuprange,2),"")

or if you're looking for an exact match:

=if(a2<="ttw",vlookup(a2,yourlookuprange,2,false),"")

and my personal preference puts that "" at the beginning:

=if(a2>"ttw","",vlookup(a2,yourlookuprange,2,true/false))

(I just find that easier to read.)

-----Original Message-----
Try this:

IF(a2<="TTW",(VLOOKUP,TTW01,TTW,2))

G



------------------------------------------------
[/url]
~~ View and post usenet messages directly from http://www.ExcelForum.com/

.
I get an invalid formula message. Any suggestions. I
Click to expand...
tries using quotes and double checked the lookup table.

Thanks
Frank
Click to expand...
 
P

Paul

"TTW" is a text string. So A2 <= "TTW" is a rather odd expression. If this
is the OP's problem, maybe he/she can explain what it's meant to do.

Dave Peterson said:
=if(a2<="ttw",vlookup(a2,yourlookuprange,2),"")

or if you're looking for an exact match:

=if(a2<="ttw",vlookup(a2,yourlookuprange,2,false),"")

and my personal preference puts that "" at the beginning:

=if(a2>"ttw","",vlookup(a2,yourlookuprange,2,true/false))

(I just find that easier to read.)

-----Original Message-----
Try this:

IF(a2<="TTW",(VLOOKUP,TTW01,TTW,2))

G



------------------------------------------------
[/url]
~~ View and post usenet messages directly from http://www.ExcelForum.com/

.
I get an invalid formula message. Any suggestions. I
Click to expand...
tries using quotes and double checked the lookup table.

Thanks
Frank
Click to expand...
Click to expand...
 
Top