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