Excel Forum



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.





Got a Question? Ask it Here in the Forum.