I am looking to put in an "IF" formula, but within that "IF" formula, if it returns false, to put in another "IF" formula, and within this do vlookup functions.
I realize this is somewhat hard to explain... maybe the below helps?
=if((leftA1="W"),(vlookup),((if(midA1="1"),(vlookup),(vlookup))...