Hi everybody.
Recently have come to the following task:

There is a table of data like this:

Piter 10 20 30
Ann 15 23 45 54 56
John 1 2 3 4 5 6

Which is treated as the values which can belong to only one person.

The task is, given the table in this awful form, get the name of
person, which possess a given number.

Suppose each person can have up to 255 values and there are 65000
people, thus, you can't rearrange table:).

The question is - how to lookup the value in the whole matrix?
Applying vlookup 255 times will not do

thanx in advance


--
Forumchanin
------------------------------------------------------------------------
Forumchanin's Profile: http://www.excelforum.com/member.php...o&userid=29600
View this thread: http://www.excelforum.com/showthread...hreadid=492998