Hello
i have the attached table that i use to enter the shipper's name on a Bill of lading, and i have a list of shippers (address + all info) in a different page. how can i pull the desired shippers info into the main page.
i tried V lookup but the info is set up in different rows and columns as seen on the attachement, any formula or keyboard shortcut, in which when I enter the first letters will I get a list of option to choose from? the List option would not work as it will not populate properly. or something similar that will help me speed up this process.
any advice will be greatly appreciated.
i have the attached table that i use to enter the shipper's name on a Bill of lading, and i have a list of shippers (address + all info) in a different page. how can i pull the desired shippers info into the main page.
i tried V lookup but the info is set up in different rows and columns as seen on the attachement, any formula or keyboard shortcut, in which when I enter the first letters will I get a list of option to choose from? the List option would not work as it will not populate properly. or something similar that will help me speed up this process.
any advice will be greatly appreciated.
Attachments
Last edited: