By Neil Shorney, 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