Nesting IF functions in a VLOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-2306895%22%20slang%3D%22en-US%22%3ENesting%20IF%20functions%20in%20a%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2306895%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20nested%20function%20statement%20to%20look%20at%20the%20data%20that%20resides%20in%20the%20cell%20and%20perform%20a%20function.%26nbsp%3B%20The%20statement%20I%20am%20using%20is%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVLOOKUP((((C6%2CATW!A2%3AH29%2C4%2CFALSE)%2C%20IF(e6%26gt%3B30)A2%2C%20IF(e6%26gt%3B15)A3%2C%20IF(e6%26lt%3B%3D15)%2Ca4)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20have%20it%20place%20the%20symbol%20if%20it%20matches%20the%20statement%20and%20it%20isn't%20working.%26nbsp%3B%20Any%20suggestions%20would%20be%20appreciated.%26nbsp%3B%20Have%20attached%20a%20screen%20shot.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2306895%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2306948%22%20slang%3D%22en-US%22%3ERe%3A%20Nesting%20IF%20functions%20in%20a%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2306948%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1040768%22%20target%3D%22_blank%22%3E%40rickdean%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20formula%20doesn't%20make%20sense%2C%20unfortunately%2C%20and%20your%20screenshot%20doesn't%20make%20it%20any%20clearer.%3C%2FP%3E%0A%3CP%3ECan%20you%20explain%20in%20detail%20what%20you%20are%20trying%20to%20do%3F%20Thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2307082%22%20slang%3D%22en-US%22%3ERe%3A%20Nesting%20IF%20functions%20in%20a%20VLOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2307082%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1040768%22%20target%3D%22_blank%22%3E%40rickdean%3C%2FA%3E%26nbsp%3BPerhaps%20you%20mean%20to%20enter%20the%20VLOOKUP%20function%20in%20E6%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DVLOOKUP(C6%2CATW!A2%3AH29%2C4%2CFALSE)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Eand%26nbsp%3Bthen%20in%20F6%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(E6%26gt%3B30%2CA2%2CIF(E6%26gt%3B15%2CA3%2CA4))%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 

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!

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