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.