Hello everyone,
I'm stuck trying to add ISNA to a multi-vlookup formula - I've tried multiple variations and each time I'm getting the "too many arguments" error. Any help is greatly appreciated!
Here is the formula, which works fine as is - I just want to exclude the #N/A since it's an eyesore
=IF($D$8="Red",VLOOKUP(A9,Worksheet1!A2:$E$396,3,FALSE),IF($D$8="Blue",VLOOKUP(A9,Worksheet1!A2:$E$396,4,FALSE),IF($D$8="Yellow",VLOOKUP(A9,Worksheet1!A2:$E$396,5,FALSE))))
Many thanks!
Bookmarks