Hi Domenic,

That does the trick! Excellent.

Thanks a million.


"Domenic" wrote in message
...
Assuming that A2:B4 contains your data, try the following formula which
needs to be confirmed with CONTROL+SHIFT+ENTER, not just ENTER...

=INDEX(A2:A4,MATCH(TRUE,ISNUMBER(SEARCH(" "&D2&","," "&B2:B4&",")),0))

...where D2 contains the 'your id' of interest, such as 90026.

Hope this helps!

In article ,
"Kok Yong Lee" wrote:

Hi there.

I have a table of the following style.

right now i tried to find some worksheet function that will take in a
number
for "my id" or "your id" and then returned the corresponding number in
"your
id" or "my id".

for a given "my id", it is relatively simple to retrieve the
corresponding
"your id" via VLOOKUP("MY ID", "ARRAY RANGE"), as "my id" is only a
single
number and sorted ascendingly.

I am struggling in geting the reverse to work. How can I retrieve the
corresponding "my id" is I were given a "your id" number?

my id your id
------------------------------------------
52177 9561
62532.01 8910
726589 90026, 8926


mnay thanks.