Help with VLOOKUP with OR

[meppwc]

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.

 

[Special-K99]

=IFERROR(VLOOKUP(H9,Table!A:W,23,FALSE),IFERROR(VLOOKUP(F9,Table!A:W,23,FALSE),""))

 

[meppwc]

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]

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.

 

[Aladin Akyurek]

If both H9 and F9 exist in Table!A:W, what is the result that you expect?