Forum Discussion
Nesting IF functions in a VLOOKUP
I am trying to create a nested function statement to look at the data that resides in the cell and perform a function. The statement I am using is: VLOOKUP((((C6,ATW!A2:H29,4,FALSE), IF(e6>30)A2...
rickdean Perhaps you mean to enter the VLOOKUP function in E6
=VLOOKUP(C6,ATW!A2:H29,4,FALSE)
and then in F6:
=IF(E6>30,A2,IF(E6>15,A3,A4))