Hi All,

I have two spreadsheets in excel 2003 and both spreadsheet have a column called 'Description' and i am trying to do a vlook up on these sheets to bring the value from one sheet to the other however the difficulty i am running accross is that the descriptions arent matching up exactly.

for instance

description in the first sheet might say
SM Allocation v6.5

description in the second list might say
SM Allocation

and i wanna run it buy you excel experts to see if you can help me any way that you might see fit.

thanks in advance.
MB