Vlookup when cell is blank

[Susannah68]

Hi, I want a vlookup which will read a different column if the 1st column is blank. I'm using the formula below, but it's returning #NA if the original column is blank and doesn't seem to be reading the alternate column.

=IF(VLOOKUP([@[Arrangement Status]],'Status Look-up'!A:B,2,FALSE)=" ",VLOOKUP([@[Submission Status]],'Status Look-up'!A:B,2,FALSE),VLOOKUP([@[Arrangement Status]],'Status Look-up'!A:B,2,FALSE))

thank you

 

[Fluff]

Hi & welcome to MrExcel.
If you mean that the arrangement status isn't found try submission status, then try

=IFNA(VLOOKUP([@[Arrangement Status]],'Status Look-up'!A:B,2,FALSE),VLOOKUP([@[Submission Status]],'Status Look-up'!A:B,2,FALSE))

 

[Susannah68]

Hi & welcome to MrExcel.
If you mean that the arrangement status isn't found try submission status, then try

=IFNA(VLOOKUP([@[Arrangement Status]],'Status Look-up'!A:B,2,FALSE),VLOOKUP([@[Submission Status]],'Status Look-up'!A:B,2,FALSE))

Brilliant, thank you for your quick response. The formula worked!

 

[Fluff]

You're welcome & thanks for the feedback.