Help with VLOOKUP with OR

meppwc

Active Member
Joined
May 16, 2003
Messages
422
I would appreciate some help with a VLOOKUP syntax issue

I am trying to add another condition (OR) to my existing formula
The formula below works correctly
=IFERROR(VLOOKUP(H9,Table!A:W,23,FALSE),"")

I want to expand it to look at both H9 or F9.
Is there a way of doing this? I searched the internet and could not find anything.
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,342
=IFERROR(VLOOKUP(H9,Table!A:W,23,FALSE),IFERROR(VLOOKUP(F9,Table!A:W,23,FALSE),""))
 

meppwc

Active Member
Joined
May 16, 2003
Messages
422
Thanks Special-K99..............I had tried the following
=IFERROR(VLOOKUP(H9,Table!A:W,23,FALSE,""),IFERROR(VLOOKUP(F9,Table!A:W,23,FALSE,"")))
Which kept failing
Now that you have provided the proper syntax I see the difference
Thanks Again
 

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,342
If you have a nested IF/IFERROR statement a easy way of remembering is you need a closing bracket for each IF statement that exists.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,139
Messages
5,466,910
Members
406,506
Latest member
donwiss

This Week's Hot Topics

Top