VLOOKUP in Column A, IFERROR, look in Column B, return value in Column C

[Nanaia]

I understand how to use VLOOKUP to find the information in column A and return the value in column C, however I don't fully understand how to incorporate a second column to look in. If the value isn't found in column A, I need the formula to then look in Column C. If the value is in column A, return the value in column C. If the value is not in column A, look for the value in column B then return the value in column C. Is this possible?

 

[Fluff]

Is this possible?

yes, it is.
Can you post the formula you're using

 

[Nanaia]

Absolutely!

=VLOOKUP([@Code],Library[[Company Color Code]:[Product-Name]],3,FALSE)

This looks in column A (Company Color Code) and returns the information in column C (Product-Name). I need to also check column B (Valspar Number) if there is no value in Column A, and return the information in Column C.

 

[Fluff]

Thanks for that.
How about

=XLOOKUP([@Code],Library[Company Color Code],Library[Product-Name],XLOOKUP([@Code],Library[Valspar Number],Library[Product-Name],,0),0)

 

[Nanaia]

Thanks for that.
How about

=XLOOKUP([@Code],Library[Company Color Code],Library[Product-Name],XLOOKUP([@Code],Library[Valspar Number],Library[Product-Name],,0),0)

You ROCK! Thank you! It works!

 

[Fluff]

You're welcome & thanks for the feedback.