Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteria
Download Excel Start File: https://people.highline.edu/mgirvin/Y...
Download Excel Finished File: https://people.highline.edu/mgirvin/Y...
Full Page With All File Links: http://people.highline.edu/mgirvin/ex...
VLOOKUP & OFFSET function Amazing Trick! See what to do if we have VLOOKUP with Duplicates in first column of lookup table AND we have two variables as criteria for VLOOKUP! We can use the VLLOKUP function to retrieve the data and the OFFSET function to look at just part of the desired table.
See the OFFSET function used as a Dynamic Range in VLOOKUP Function.