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? |
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? |
All times are GMT +1. The time now is 10:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com