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


--
VincentT
------------------------------------------------------------------------
VincentT's Profile: http://www.excelforum.com/member.php...o&userid=26046
View this thread: http://www.excelforum.com/showthread...hreadid=393930