fbo212
06-01-2007, 10:15 AM
I was told that there is a way to combine 2 files into one huge one using VLOOKUP. The first file (File A) contains a list of companies and banks and is organised catagorically by country. For example under the Country is a list of 5 or 6 entries. However in the second file (File B) each entry has the company name in column A and the country in Column B. Is there a way to bring the information in file A in the format of File B?
Any help on the subject would be appreciated.
:banghead:
Any help on the subject would be appreciated.
:banghead: