See the "Arbitrary Lookups" section he

http://cpearson.com/excel/lookups.htm


In article . com,
"Valley" wrote:

My meaning is

If the matching value is two or more, how to catch the second and the
third and more.

For example,
Value is 16444050(in columnA1 and A2) in sheet1
There are 16444050(in column A1 and A2) and 22401241(in column B1) and
224016549(in column B2) in sheet2

When using vlookup, it can only catch B1 but not B2 of sheet2, how to
catch B1 and B2, or how to catch B2 but not B1?