IF and Vlookup formula

[Smashsmash]

Would 2 vlookups work on an IF function?

I have =IF(G2<>H2,VLOOKUP(O2,Sheet2!E:F,2,FALSE),VLOOKUP(O2,Sheet2!A:B,2,FALSE))

but the false return gives me #NA

I have G2 and H2 as not equal which gives me the answer and if G2=H2 should give the result on the table array

any thoughts?

[JohnTopley]

Not without a workbook! Please see yellow banner at top of the page on how to attach a workbook.

[Smashsmash]

attaching file here for reference

[JohnTopley]

Guessing

VLOOKUP should be reversed

=IF(G2<>H2,VLOOKUP(O2,Sheet2!A:B,2,FALSE),VLOOKUP(O2,Sheet2!E:F,2,FALSE))

or

=IF(G2=H2,VLOOKUP(O2,Sheet2!E:F,2,FALSE),VLOOKUP(O2,Sheet2!A:B,2,FALSE))

[Smashsmash]

Guessing

VLOOKUP should be reversed

=IF(G2<>H2,VLOOKUP(O2,Sheet2!A:B,2,FALSE),VLOOKUP(O2,Sheet2!E:F,2,FALSE))

or

=IF(G2=H2,VLOOKUP(O2,Sheet2!E:F,2,FALSE),VLOOKUP(O2,Sheet2!A:B,2,FALSE))

Yea, I tried that also, it doesn't follow my intended outcome which is weird cause afaik it should work, right?

[JohnTopley]

'No Show - day 1" is in column E and your formula is looking at column A when G2=H2: hence my response.

[JohnTopley]

There are many selections in O2 which will return #N/A so perhaps you need to tailor the O2 drop down to only have valid conditions if G2:H2.

[Smashsmash]

'No Show - day 1" is in column E and your formula is looking at column A when G2=H2: hence my response.

OMG lol I totally missed that! Just needed the full list of the array