Any Excel Gurus?

Alpine3

Alpine3

Active member
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))

somewhat complicated, but would appreciate any help. I can't seem to get it to populate an answer
 
ha no, this is for work. but i suppose this might be something covered in an M.I.S.

i have a bachelors in finance but no solid IS skills.
 
Just a quick glance I think you're missing one or two more ) at the end. When you enter them in excel at the end, it should correspond in color to the parenthesis you are finishing. Make sure all parenthesis are closed. Not sure if this is your problem

Also, you haven't properly finished your v-lookups. Instead of just manually entering it in there, pull up the actual function box and fill out everything for each v-lookup. I hope that makes sense.

idk if that example is exactly what you have in excel, but neither the if function(s) nor the v-lookups are finished.
 
Also, your return response for the first if function is a vlookup, not another if function. Take out the first vlookup and move the if function over to the "false" response.

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

somewhat complicated, but would appreciate any help. I can't seem to get it to populate an answer

So you want to nest an IF within an IF, and then a vLookup within the second IF?

=IF(leftA1="W",value if true, IF(

put your new IF( where the "value_if_false" would appear, and then you have a completely new IF function within the first IF function. I could be of much more help if I could have the spreadsheet in front of me, I usually have to fuck around with it before i get it to populate.

And then it depends if you want your vlookup to be the false value or the true value in the nested if.

PM me if you want, I love excel
 
You have 8 left paranetheses and only 6 right parentheses. Once you fix that it might give you another error message but that is why you are getting the Too Few Arguements message.

Double nested conditionals are a bitch.
 
=IF((LEFT(A1642,1)="w"),(VLOOKUP((MID(A1642,3,1)),'Sheet1'!$AN$3:$AR$30,5,0)),(IF((VLOOKUP(MID(A1642,2,1)),'Sheet1'!$AT$3:$AU$35,2,0)="1"),(VLOOKUP(MID(A1642,3,1)),'Sheet1'!$AN$5:$AR$30,5,0),(VLOOKUP(MID(A1642,3,1)),'Sheet1'!$AG$5:$AK$27,5,0)))

 
Dont you have to put a true, False, and a number range in there?

Thats just what I remember from doing that in one of my business classes three years ago
 
i'm pretty sure i could write this for you, but I'd need to see the data that you're working with to be able to really understand it. i'm assuming it's confidential though? if not, and you want to email me your file, I'll try and help you write this. not to toot my own horn, but I'm pretty damn good with nested formulas.
 
hey thanks for offering to help man! i was able to figure it out thankfully, did it a little different though. Unfortunately it is confidential. ill definitely reach out to ya next time tho.
 
You must log in or register to reply here.
Back
Top