Most valuable professional
  • Excel Book Excerpt

Excel Consider Naming the Lookup Table

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.

Consider Naming the Lookup Table

Problem: My lookup table is on another worksheet. The VLOOKUP is really confusing =VLOOKUP(A2,’Lookup Table Sheet’!$A$2:$B$30,2,FALSE).

Strategy: Many people in my live seminars say that they use a range name to name the lookup table. Go to your Lookup Table Worksheet. Select cells A2:B30. Click in the Name Box to the left of the formula bar. Type a simple name like ProdTable and press Enter.

Future VLOOKUPs can be entered as: =VLOOKUP(A2,ProdTable,2,FALSE). This is simpler to enter.

<-Previous Topic                    Next Topic->

For more resources for Microsoft Excel: