Long formula breaks when adding nested IF

**mgumapas** · 02-27-2020, 06:21 PM

Can someone look at this formula and tell me what i'm doing wrong.
The formulas individually work, but when i try to put it in a nested if, it won't let me. I know it has something to do with the parenthesis, but i can't figure it out.

Please help!

=IFERROR((VLOOKUP($E8,'Pandora Worksheet'!$E:$AB,MATCH(G$6,'Pandora Worksheet'!$E$2:$AB$2,0),FALSE)),IFERROR((VLOOKUP($D8,'Pandora Worksheet'!$D:$AB,MATCH(G$6,'Pandora Worksheet'!$D$2:$AB$2,0),FALSE)),(VLOOKUP($c8,'Pandora Worksheet'!$c:$AB,MATCH(G$6,'Pandora Worksheet'!$c$2:$AB$2,0),FALSE),(VLOOKUP($b8,'Pandora Worksheet'!$b:$AB,MATCH(G$6,'Pandora Worksheet'!$b$2:$AB$2,0),FALSE),(VLOOKUP($A8,'Pandora Worksheet'!$A:$AB,MATCH(G$6,'Pandora Worksheet'!$A$2:$AB$2,0),FALSE)))))

**6StringJazzer** · 02-27-2020, 06:39 PM

We can't fix it without knowing what it's supposed to do. This is a pretty convoluted formula--please describe the logic you want this to follow. There is a syntax error to begin with--what nested IF are you trying to put in?

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Help with formula" is not a good title. I have updated it for you this time because you are a new member. --6StringJazzer

**mgumapas** · 02-27-2020, 07:28 PM

Hi,
I apologize. First time posting a thread and didn't read the rules first.

I was able to figure out the formula on my own.

Thanks for your help.

At least I know how to post going forward.