• 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?

LE10000435.jpg 

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.

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: