Basic Excel If Logic Question

it is the vlookup that is returning #N/A

1. find out which vlookup is causing the #N/A
2. then manually check if the lookup_value is in the range, if not it will return #N/A
3. use wild cards if needed in the lookup_value i.e vlookup("*" & [cel] & "*",....,....,....)

Yeah, I know it is the VLOOKUP.

The formula returns the expected values as long as the very last VLOOKUP is not there. However, once it is added, it causes an issue.

If I do that VLOOKUP on it's own, it works. It has something to do with how I am viewing the IF logic I believe.

I tried to create another IF and just make it IF(ISBLANK(B11),VLOOKUP.... and IF(B11="",VLOOKUP...

Neither of those worked either... not sure why.

Yes, I think you need to check B11 first, does this work?

=IF($B$11="",VLOOKUP(B9,Standards,2,FALSE),VLOOKUP($B$11,INDIRECT("_"&B9&"Standards"),2,FALSE))

Originally Posted by daddylonglegs

Yes, I think you need to check B11 first, does this work?

=IF($B$11="",VLOOKUP(B9,Standards,2,FALSE),VLOOKUP($B$11,INDIRECT("_"&B9&"Standards"),2,FALSE))

Wow, that is much easier than 6 nested if statements... thanks so much!