Greetings All
I realy urgently need excel formula help here please...I am sure it can be done.
1] I extract batches of information which is copied to cell "A1:A1000" by example in "A1":
"INET IMMEDIATE PMT ABSA BANK KOBA IT SOLUTIONS 1600D807B2"
2] I have a excell database with various predefined name entries i.e.
KOBA IT SOLUTIONS
MUSTEK SA
NORBAIN SOLUTIONS
3] I need a formula to look-up or find in the whole description mentioned in cell "A1" or to find something mentioned with "Koba" and copy it to cell "B1" with the pre-defined database description "KOBA IT SOLUTIONS".
If anybody can help me, it will be grately appreciated and if you could mail me the solution to : [email protected]
Appreciated and regards
Anton
Bookmarks