I spent a great deal of time today looking through several options of VLOOKUP, HLOOKUP, XLOOKUP, and other Index and Match scenarios but could not seem to get things working correctly. I always ended with the result being either from the same row or of the type #VALUE! error.
If exist in a...