How do you do a two way lookup in Excel?

To do a two-way lookup in an Excel Table, you can use the MATCH function with a structured reference and VLOOKUP. In the example shown, the formula in I5 (copied down) is: =VLOOKUP($I$4,Table1,MATCH(H5,Table1 Headers…
For More Information Please Refer:

You May Also Like to Read: