N
NeedToKnow
Hi all, I have tried to search old messages without luck.
I have 2 files which has column A = Vendor name, col B = order value EUR,
C-f = other data. I need to find vendor from older file ti new file and get
order value there. It doesn't matter if column G = vendor name from old file
and col H order value from old file.
This would be easy with vlookup IF all names were written correctly. Many
people make these and misspelling happens. I have figured something like
this, tell if tjere is easier way.
= IF (vlookup to find excatly same name (lookup to get value) ond if excatly
the same vendor cannot be found, there would be nearest suggestion and that
vendors value ) if not anything even close can be found, excel would informs
something like "check" or like that.
Is it possible to have checking if some vendor is not at all in new file?
That's all this time =) I think. You have been a huge help in past,
hopefully also this case can be solved. I have Excel 2003 in use.
I have 2 files which has column A = Vendor name, col B = order value EUR,
C-f = other data. I need to find vendor from older file ti new file and get
order value there. It doesn't matter if column G = vendor name from old file
and col H order value from old file.
This would be easy with vlookup IF all names were written correctly. Many
people make these and misspelling happens. I have figured something like
this, tell if tjere is easier way.
= IF (vlookup to find excatly same name (lookup to get value) ond if excatly
the same vendor cannot be found, there would be nearest suggestion and that
vendors value ) if not anything even close can be found, excel would informs
something like "check" or like that.
Is it possible to have checking if some vendor is not at all in new file?
That's all this time =) I think. You have been a huge help in past,
hopefully also this case can be solved. I have Excel 2003 in use.