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)+ROW (dataRange)-1)
for the product name, and

=INDEX(3:3,INDEX(ArrayMatch(F1,dataRange),1,2)+COL UMN(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