Hi all. I need a macro that will best match data in sheet 2 to data entered
by a user in sheet 1 A1:10 for example. I need it to look at column A in
sheet 2 and return the value in column B and keep looping through the values
in sheet A1:Ax until it comes to a blank cell. I need the query to be on a
best match basis, knocking off numbers from the right of those entered in
sheet 1.

Does this make sense? Can anyone help?

Jas,

Can you post a bit of the data? Is the data text, numbers, etc. and how do
you want to determine the "Best Match?"

Mike

"Jas" wrote:

Hi all. I need a macro that will best match data in sheet 2 to data entered
by a user in sheet 1 A1:10 for example. I need it to look at column A in
sheet 2 and return the value in column B and keep looping through the values
in sheet A1:Ax until it comes to a blank cell. I need the query to be on a
best match basis, knocking off numbers from the right of those entered in
sheet 1.

Does this make sense? Can anyone help?