I'm trying to combine two formulas into one result.

I have this formula:
=IF(ISNA(VLOOKUP("Bin"&$A6&"Month"&F$3,Entry!$A:$S,19,FALSE)),VLOOKUP("Bin"&$A6&"Month"&F$3,Entry!$A:$S,19,FALSE),"Empty")

and if it doesn't pull up any output, then I'd like for it to look one cell to the left to see if it = "Hang", and for this formula to also display a subsequent "Hang". How do I do that? I keep having issues.

I've just come across this and its probably been resolved but i don't understand neither the formula nor the question.

for the formula if you return #N/A then you do the Vlookup !!

What do you mean the Cell to the Left, the left of what?

Brian