Nesting IF functions in a VLOOKUP

[rickdean]

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]

@rickdean 

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!

[#3]

@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))