How can i merge three xlook ups into one formula

Copper Contributor

If i use three different xlook ups in 3 different columns i can get my result. But i want to do this in one cell using one formula. 


How do i merge these formulas? Each formulas look up will rely on the previous look up result 






3 Replies


Does this do what you want?



That returns #N/A unfortunately


Which cells contain the formulas in your first post?

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?