If(or) with vlookup getting n/a

[brooksc29]

Can anyone tell me why this code will return N/A even though when I walk through it the steps look like it should return an actual result?

=IF(OR($I$3="RHP",$I$3="LHP",VLOOKUP($G$3,STATS19pitch,16,FALSE)),VLOOKUP($G$3,STATS19sb,15,FALSE))

 

[Joe4]

What exactly are you trying to check with the last argument in your OR clause?

[COLOR=#333333]VLOOKUP($G$3,STATS19pitch,16,FALSE)[/COLOR]

You haven't set it equal to anything.

Or is that supposed to be the TRUE clause (second argument) of you IF statement?
If so, you have a misplaced parenthesis.
Does this give you want you want?

[COLOR=#333333]=IF([/COLOR][COLOR=#0000ff]OR($I$3="RHP",$I$3="LHP")[/COLOR][COLOR=#333333],[/COLOR][COLOR=#008000]VLOOKUP($G$3,STATS19pitch,16,FALSE)[/COLOR][COLOR=#333333],[/COLOR][COLOR=#ff0000]VLOOKUP($G$3,STATS19sb,15,FALSE)[/COLOR][COLOR=#333333])[/COLOR]

(note how I color coded each clause in your IF, and each clause has balanced parentheses)

 

[brooksc29]

yes, this works excellently.

thanks for the correction, Joe4!

 

[Joe4]

You are welcome.