Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help!
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 Id 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 wont able to use vlookup function. Can anyone help me to come up a formula? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|