Re: Using a reference to return a value 'n' columns and rows away from the search res

Many thanks for the quick reply!

The problem is I first need to do some kind of search function to initially find the 'A1' in your example, and use offset to return the value a certain number of cells away from the search result 'A1'.

So I want to use a reference (which is a product code), search a table of data to pick up that product code, and then return a piece of data about that product (e.g. weight) which will always be positioned three rows down and two columns to the right of the product code in the table. This is so I can repopulate the data into a different table which also has the product codes.

So maybe the formula would look something like:

=OFFSET(the cell reference of the search result,3,2)

Thanks again!

Hestar