On May 1, 2:22 am, Gord Dibben <gorddibbATshawDOTca wrote:
Alternate method.

With names in A2:A10 and products in B1:H1

InsertNameCreate. Checkmark top row and left column.

Formula would then be =name1 product4 to get the intersected value.

Gord Dibben MS Excel MVP
Hello Gord:
I liked your solution and tried it with success, I would like to
expand it by having the names being dynamic.. (a name in a seperate
cell and the product in a different cell.) such as =a1 b1. is this
possible? is there a formula to do this?
I know how to use the index and match formulas but this could be a
much easier way to find the value in the appropriate cell.

thanks
Stan