If(or) with vlookup getting n/a

brooksc29

Active Member
Joined
Jul 25, 2010
Messages
328
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,771
Office Version
365
Platform
Windows
What exactly are you trying to check with the last argument in your OR clause?
Code:
[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?
Code:
[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)
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,771
Office Version
365
Platform
Windows
You are welcome.
 

Forum statistics

Threads
1,085,314
Messages
5,382,916
Members
401,808
Latest member
huyennhiteen9xx

Some videos you may like

This Week's Hot Topics

Top