Thursday, December 28, 2017

Excel Left Lookup

Excel's VLOOKUP is a great tool to search one column of a table for a match and return data from another column.  That is, great as long as the match column is left of the data you want returned.  If it's to the right, VLOOKUP will fail you.  But a clever combination of MATCH and INDEX will save your bacon, as detailed at this link.

No comments:

Post a Comment