Trying to Automate using Index Match

%3CLINGO-SUB%20id%3D%22lingo-sub-3268196%22%20slang%3D%22en-US%22%3ETrying%20to%20Automate%20using%20Index%20Match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3268196%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20file%20with%20three%20sheets%20as%20per%20attached%20example.%3C%2FP%3E%3CP%3EThe%20first%20sheet%20carries%20the%20information%20for%20all%20the%20Consignees%2C%20their%20addresses%20and%20the%20customs%20agents%20addresses.%3C%2FP%3E%3CP%3EThe%20second%20sheet%20is%20where%20I%20need%20to%20select%20the%20consignee%20from%20the%20Main%20table%20who%20has%20an%20order%20to%20deliver.%3C%2FP%3E%3CP%3EOn%20the%20third%20sheet%20called%20%22%20for%20emailing%22%2C%20I%20need%20the%20data%20looked%20up%20from%20the%20%22consignees%20selection%20sheet%22%20and%20arranged%20in%20such%20a%20way%20that%20I%20can%20easily%20email%20it.%20I%20have%20tried%20to%20use%20INDEX%20Match%20to%20Lookup%20the%20addresses%20from%20the%20main%20sheet%2C%20but%20it%20does%20not%20give%20me%20the%20desired%20results.%20Please%20help%20me%20here..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3268196%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3268665%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20Automate%20using%20Index%20Match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3268665%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481153%22%20target%3D%22_blank%22%3E%40A_SIRAT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20is%20different%20from%20what%20you%20first%20asked...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3268323%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20Automate%20using%20Index%20Match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3268323%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20explain%20it%20again..I%20have%20a%20file%20with%20two%20sheets%20namely%20Consignee%20Main%20and%20Consignees%20Selection.%20The%20Main%20file%20has%20contacts%20for%20all%20Companies%20and%20their%20Customs%20agent.%20What%20I%20want%20on%20the%20%22%20Consignees%20selection%22%20File%20is%20to%20select%20any%20company%20that%20I%20want%20to%20work%20with%2C%20and%20then%20to%20lookup%20the%20addresses%20of%20that%20Company%20from%20the%20Consignee%20Main%20sheet.%20For%20example%2C%20If%20I%20select%20on%20the%20selection%20sheet%20A2%2C%20XYZ%20with%20certain%20Airport%2C%20then%20I%20should%20get%20its%20address%20looked%20up%20from%20the%20Main%20table%20and%20populated%20from%20column%20D%20onwards.%20I%20have%20attached%20another%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3268201%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20Automate%20using%20Index%20Match%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3268201%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F481153%22%20target%3D%22_blank%22%3E%40A_SIRAT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20not%20entirely%20clear%20to%20me%20what%20you%20want%2C%20but%20take%20a%20look%20at%20the%20attached%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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..

3 Replies

@A_SIRAT 

It's not entirely clear to me what you want, but take a look at the attached version.

@Hans Vogelaar 

 

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.

@A_SIRAT 

That is different from what you first asked...