Multiple VLOOKUP in One Cell

[meppwc]

I have a formula in K12 as seen below
=IFERROR(VLOOKUP(F12,Table!A:W,23,FALSE),"")

I want to modify it to look at values in both F12 and H12, so I created the following
=IFERROR(VLOOKUP(F12&H12,Table!A:W,23,FALSE),"")

Even though the formula did not error out (syntax must be correct), I am not getting the expected result.

What I am hoping to achieve is if a value exists in either F12 or H12, then look for that value in A:W of the Table
If found, display the value of column 23 which is "No"

This formula is returning nothing and should return "No"
=IFERROR(VLOOKUP(F12&H12,Table!A:W,23,FALSE),"")
So I had to of created it incorrectly

 

[JoeMo]

F12&H12 concatenates the two cells so if F12 is "Tom" and H12 is "Brown" then you are looking up "TomBrown". You could try:

=IFERROR(VLOOKUP(F12,Table!A:W,23,FALSE),IFERROR(VLOOKUP(H12,Table!A:W,23,FALSE),""))