New to the forum, thank you in advance<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
I have Excel spreadsheet with shipments information, carriers name and tracking numbers. I need to populate delivery date and shipping cost which is available in other Excel files. How I can connect it?<o></o>
Basically I need formula which will take tracking # in file A and search for same tracking # in spreadsheet B, if tracking # is found it will look in same file for delivery date and charges and write information back to spreadsheet A in columns right next to tracking #. If tracking # not found in spreadsheet B, it will go and look spreadsheet C, etc, up to 10 files.<o></o>
I know how to use VLOOK UP formula but in this case I need to look for multiple tables.<o></o>
Can someone suggest simpler way?<o></o>
fficeffice" /><o></o>I have Excel spreadsheet with shipments information, carriers name and tracking numbers. I need to populate delivery date and shipping cost which is available in other Excel files. How I can connect it?<o
></o>Basically I need formula which will take tracking # in file A and search for same tracking # in spreadsheet B, if tracking # is found it will look in same file for delivery date and charges and write information back to spreadsheet A in columns right next to tracking #. If tracking # not found in spreadsheet B, it will go and look spreadsheet C, etc, up to 10 files.<o
></o>I know how to use VLOOK UP formula but in this case I need to look for multiple tables.<o
></o>Can someone suggest simpler way?<o
></o>
