thewiseguy
Wellknown Member
 Joined
 May 23, 2005
 Messages
 807
 Office Version

 365
 Platform

 Windows
Hi all. Having trouble combining functions.
Here is my formula which needs some work:
=IFERROR(VLOOKUP(B2,INDIRECT(VLOOKUP(C2,TableNames,2)),8,0),"")
instead of returning the value in the 8th column, I want to add these IF conditions:
=IF(E2≤20,17)
=IF(E2 is between 2150, 18)
=IF(E2 is between 51100, 19)
=IF(E2 ≥ 100,20)
is this possible?
many thanks in advance.
Here is my formula which needs some work:
=IFERROR(VLOOKUP(B2,INDIRECT(VLOOKUP(C2,TableNames,2)),8,0),"")
instead of returning the value in the 8th column, I want to add these IF conditions:
=IF(E2≤20,17)
=IF(E2 is between 2150, 18)
=IF(E2 is between 51100, 19)
=IF(E2 ≥ 100,20)
is this possible?
many thanks in advance.