#Incorrect Argument Set

aplunkett02

I am trying to create a multiple IF statement, but am receiving #Incorrect Argument Set. I am trying to figure out what is wrong with my formula to cause this issue. Below is my formula:

=IF((Region@row = "CA"), "No", IF((VLOOKUP([Category 2]@row, {Product Classifications Range 2}, 4, false)) = "Face"), "Yes", IF((VLOOKUP([Category 1]@row, {Product Classifications Range 2}, 3, false)) = "Bath & Body"), "Yes", (VLOOKUP(Brand@row, {Brand Classifications Range 2}, 9, false)))

Carson Penticuff

Try this:

=IF(Region@row = "CA", "No", IF(VLOOKUP([Category 2]@row, {Product Classifications Range 2}, 4, false) = "Face", "Yes", IF(VLOOKUP([Category 1]@row, {Product Classifications Range 2}, 3, false) = "Bath & Body", "Yes", VLOOKUP(Brand@row, {Brand Classifications Range 2}, 9, false))))

aplunkett02

Hi Carson,

Thank you for your suggestion, unfortunately, I am still receiving the same error.

bbates

You have too many parenthesis in your if statements that the values are aligning and not enough at the end of the statement to close out all of the formulas. Try this:

=IF(Region@row = "CA", "No", IF(VLOOKUP([Category 2]@row, {Product Classifications Range 2}, 4, false) = "Face", "Yes", IF(VLOOKUP([Category 1]@row, {Product Classifications Range 2}, 3, false) = "Bath & Body", "Yes", (VLOOKUP(Brand@row, {Brand Classifications Range 2}, 9, false)))))

Carson was close but 5 ) are required at the end of this.

Carson Penticuff

@bbates Both of our formulas do the same thing. You have an extra open paren before the last VLOOKUP statement that requires the extra closing paren to close out. It doesn't cause an issue... I have both formulas working in a test sheet.

@aplunkett02 My best guess is that one of your cross sheet references is incorrect. Can you verify that {Product Classifications Range 2} is at least four columns and {Brand Classifications Range 2} is at least nine columns?

aplunkett02

@Carson Penticuff that was the issue! My reference wasn't including the need cell, once updating it worked! Thank you!

Carson Penticuff

Awesome! I'm glad it's working for you now. 👍

NikkiGeo

Thanks!!