Hello all, any help gratefully received on the following please. I have a workbook with 2 worksheets. Sheet 2 uses a vlookup to search for values in Sheet 1. The problem is that for every one column the vlookup moves to the right in Sheet 2, the lookup range needs to change in Sheet 1 by 3 columns. I can't work out how to combine vlookup with index or match of offset to do this. In the attachment, cell D6 (almonds) in Sheet 2 needs to lookup with value for E3 (almonds) in sheet EB. The value for Almonds for each type of product is not in the same row in sheet EB
Bookmarks