Advanced formula related to VLOOKUP

Hi everyone,

I'm looking for some help with an advanced formula. I am using VLOOKUP which is populating correctly. However, when it does not find a match, I would like it to pull in a value from another column.  This is what my formula looks like so far:

=VLOOKUP([@[Color]],BH:BP,2,FALSE)

When it does not find a match in the array, I would like the cell to populate with what is in AZ2. How would I add that to my existing formula without affecting the VLOOKUP?

Thank you!