Help!

M

momotaro

I have a list of descriptions which I downloaded from the bank –“SHEET1†TAB.
• DISCOVER NETWORK DES:SETTLEMENT ID:123456789101112,INDN:ABC COMPANY CO
ID:657891011 CCD
• BANKCARD DES:SETTLEMENT ID:123456789101118,INDN:ABC COMPANY CO
ID:657891011 CCD
• AMERICAN EXPRESS:SETTLEMENT ID:220000235,INDN:ABC COMPANY CO ID:657891011
CC
I also have an ID list- “SHEET2†TAB.
• ID:123456789101112 - ABC COMPANY
• ID:123456789101118 – THE APPLE
• ID:220000235 – FLOWERS

What I’d like to do is to set up a formula that can link both together. For
example, look at the ID # (ID:123456789101112) on sheet1 tab and sheet2 tab,
give me the result. The result here should be “ABC COMPANYâ€. I know I
won’t able to use vlookup function. Can anyone help me to come up a formula?
Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help w/ formula referring to different tabs & different info in ce 0
Help With First attempt at Database Relationships 2
Ribbon callback error 1
automating use of complicated formula 4
MAX/MAXA – Formula not returning required value 6
Index Match Between 3 Sheets 3
Gannt chart: formulas and conditional formatting 3
Merging excel documents....help! 0

Top