On Mar 18, 5:49*pm, zvkmpw wrote:
Looks great, and works nicely. Thank you.
Pete

I put the original data in Sheet1, with additional products in four-
column blocks F:I, J:M, etc.

In Sheet2, I used these parameters:
* name in A1,
* option in A2,
* product ID in A3.

In Sheet2!A4, this formula seems to get the desired result:
* *=OFFSET(Sheet1!A1,
* * * *MATCH(A1,Sheet1!A:A,0)-1,
* * * *MATCH(A3,Sheet1!2:2,0)+A2-2)
[Since Sheet1!B1:M1 is so regular, there's no need to MATCH the
"option," just count columns.]

Hope this helps getting started.

You might want to add tests in case there isn't a match, or in case
you want an empty cell in Sheet1 to not return a zero in Sheet2!A4.- Hide quoted text -

- Show quoted text -