Tuesday 16 April 2013

Performing backwards lookups in Microsoft Excel

By , Director, Naturally Sales Ltd.

The most common ways of looking up data in Excel are the VLOOKUP and HLOOKUP functions. One drawback of using this method of finding data, is that they can only look up data from left-to-right (VLOOKUP) or top-to-bottom (HLOOKUP). In Advanced Microsoft Excel, we learn about backwards lookups, but as a work-around, you can copy and paste the column from which you'd like to return a value, to a blank column at the end of the data set, then do a normal forward lookup to return the data you need.

Click here to download an Excel file with step-by-step instructions.

No comments:

Post a Comment