Here are examples of VLOOKUP and various lookup alternatives:
Intersecting Lookup With Multiple Criteria
Handling multiple OR Lookup Criteria
Reverse intersecting lookup: return row and header labels
Lookup first and last values along row
Lookup and address of last instance
Lookup column header for first non-zero-containing cell along a row
Leave a Reply