Скачать или смотреть Reverse Lookup Across Multiple Columns in Excel !!!

🔍 Learn how to do a reverse lookup in Excel when your lookup value could be in any of several columns, but the result always comes from a single output column.

In this tutorial, I’ll show you how to use:
(1) TOCOL to flatten your lookup range
(2) MATCH to find the position of the value
(3) ROUNDUP to calculate the matching row
(4) INDEX to return the correct result

📌 Formula used:

=INDEX($A$8:$A$26, ROUNDUP(MATCH(K18, TOCOL($B$8:$I$26), 0)/8, 0))

✅ Ideal for:
(1) Reverse VLOOKUPs:
(2) Category lookups across multiple codes
(3) Clean, formula-only solutions (no helper columns or VBA!)

🧠 Works perfectly in Excel 365 or Excel 2021 with dynamic arrays.

🔔 Subscribe to Excel with Sumit for more advanced and practical Excel tutorials:    / @excelwithsumit  

#ExcelReverseLookup #TOCOL #ExcelWithSumit #IndexMatch #ExcelTips #ReverseVlookup #ExcelFormula