Best match macro
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?
|