How to Perform a Two-Way Lookup in Microsoft Excel. This article provides instructions on how to perform a two-way lookup in Microsoft Excel. Scenario: Suppose you need to find a value from a table without directly looking it up in the table. You require a formula that can match both a row index and a … Continue reading How to Perform a Two-Way Lookup in Microsoft Excel