Mar 27 2022 01:42 PM
Hi,
I have a file with three sheets as per attached example.
The first sheet carries the information for all the Consignees, their addresses and the customs agents addresses.
The second sheet is where I need to select the consignee from the Main table who has an order to deliver.
On the third sheet called " for emailing", I need the data looked up from the "consignees selection sheet" and arranged in such a way that I can easily email it. I have tried to use INDEX Match to Lookup the addresses from the main sheet, but it does not give me the desired results. Please help me here..
Mar 27 2022 02:02 PM
It's not entirely clear to me what you want, but take a look at the attached version.
Mar 27 2022 07:46 PM
Let me explain it again..I have a file with two sheets namely Consignee Main and Consignees Selection. The Main file has contacts for all Companies and their Customs agent. What I want on the " Consignees selection" File is to select any company that I want to work with, and then to lookup the addresses of that Company from the Consignee Main sheet. For example, If I select on the selection sheet A2, XYZ with certain Airport, then I should get its address looked up from the Main table and populated from column D onwards. I have attached another file.
Mar 28 2022 04:13 AM
That is different from what you first asked...