I assume you mean duplicate sales values.

=INDEX($3:$3,INDEX(ArrayMatch($F$1,dataRange),ROW( A1),2)+COLUMN(dataRange)-1)
for the customer name

=INDEX(B:B,INDEX(ArrayMatch($F$1,dataRange),ROW(A1 ),1)+ROW(dataRange)-1)
for the product name

If you enter them in two horizontally adjacent cells and fill down, you
will get the results for each occurrence of the duplicated sales value.

Alan Beban

Biff wrote:
What if there are duplicates?

Biff

"Alan Beban" wrote in message
...

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, then if the
range of your data, including the headers, is named "dataRange", the
specified sales value is in Cell F1, Column B is the first column of
dataRange and Row 3 is the first row of dataRange:

=INDEX(B:B,INDEX(ArrayMatch(F1,dataRange),1,1)+R OW(dataRange)-1)
for the product name, and

=INDEX(3:3,INDEX(ArrayMatch(F1,dataRange),1,2)+C OLUMN(dataRange)-1)
for the customer name

Alan Beban

VincentT wrote:

Good afternoon,

Would anyone have some suggestion on how to proceed with the problem
below?

I have a table organised as follows:

Columns = different customers
Rows = different products
Table cells = sale value of each combination customer-product.

Given one of the sale value in the table, how to find back the
corresponding customer and product names?

This is no problem for an array (i.e. either one customer or one
product) using INDEX / MATCH, but how to do it for a table? A kind of
two-way match or reverse two-way lookup?

Many thanks in advance,

Cheers,

Vincent