If/Vlookup Statement

  • Thread starter Thread starter FrankB
  • Start date Start date
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
 
=IF(A2<="TTW",VLOOPUP(lookup_value,loouup_table,column_number,true/false),""
)
Bernard
 
=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.)
 
"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.
 
Back
Top