|
Featured Tutorial
Featured Macro
Excel Magic Trick # 158: VLOOKUP w 2 Variables As Criteria
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.
See the OFFSET function used as a Dynamic Range in VLOOKUP Function.