- Excel Book Excerpt
Excel Your Lookup Table Can Go Across
This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Your Lookup Table Can Go Across
Problem: Someone built this lookup table going across the worksheet. How can I use VLOOKUP?
Figure 429 The table is going the wrong way.
Strategy: The “V” in VLOOKUP stands for Vertical Lookup. Excel also offers an HLOOKUP for horizontal lookup tables. If you are in a bizarre mood, you could actually use HLOOKUP: =HLOOKUP(B3,$F$2:$Q$3,2,FALSE).
Alternate Strategy: You will most likely do what I and every other person using Excel does: Copy F2:Q3. Select cell F5. Do Paste, Transpose. This turns the lookup table back so it is vertical. Then you can do a VLOOKUP.
For more resources for Microsoft Excel: