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, IF(e6>15)A3, IF(e6<=15),a4)
I am trying to have it place the symbol if it matches the statement and it isn't working. Any suggestions would be appreciated. Have attached a screen shot.
2 Replies
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))
The formula doesn't make sense, unfortunately, and your screenshot doesn't make it any clearer.
Can you explain in detail what you are trying to do? Thanks in advance!
