thewiseguy
Well-known Member
- Joined
- May 23, 2005
- Messages
- 954
- 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 21-50, 18)
=IF(E2 is between 51-100, 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 21-50, 18)
=IF(E2 is between 51-100, 19)
=IF(E2 ≥ 100,20)
is this possible?
many thanks in advance.