LOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-2252429%22%20slang%3D%22en-US%22%3ELOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2252429%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrying%20to%20look%20up%20a%20r%C3%A9f%C3%A9rence%20and%20a%20data%20corresponding%20to%20the%20ref.%26nbsp%3B%20in%20a%20first%20excel%20sheet%20in%20two%20differents%20column%2C%20look%20for%20the%20same%20reference%20in%20a%20second%20worksheet%20to%20affect%20the%20data%20in%20a%20blank%20coumn%20on%20the%20same%20line%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EReason%20%3A%20I%20have%26nbsp%3B%20datas%20frome%20different%20sources%20and%20worksheet%20which%20need%20to%20be%20reconciliated%20and%20placed%20in%20only%20one%20worksheet%20integrating%20the%20differents%20information%20received....from%20the%20different%20ones.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2252429%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2253124%22%20slang%3D%22en-US%22%3ERe%3A%20LOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2253124%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1016334%22%20target%3D%22_blank%22%3E%40pierremile2008%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20may%20illustrate%20the%20question%20by%20small%20sample%20file%2C%20it's%20not%20clear%20how%20the%20data%20is%20structured%20and%20what%20you'd%20like%20to%20achieve.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2253329%22%20slang%3D%22en-US%22%3ERe%3A%20LOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2253329%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20for%20your%20answer%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20the%20two%20files%2C%20there%20are%20in%20reality%26nbsp%3B%20in%20two%20difrent%26nbsp%3B%20files%20names%2C%20look%20easy....but%20cannot%20find%20the%20way......%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20a%20lot%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

Trying to look up a référence and a data corresponding to the ref.  in a first excel sheet in two differents column, look for the same reference in a second worksheet to affect the data in a blank coumn on the same line ? 

 

Reason : I have  datas frome different sources and worksheet which need to be reconciliated and placed in only one worksheet integrating the differents information received....from the different ones.

 

thanks  

6 Replies

@pierremile2008 

Perhaps you may illustrate the question by small sample file, it's not clear how the data is structured and what you'd like to achieve.

@Sergei Baklan 

 

Hi, 

thanks for your answer,

 

Below the two files, there are in reality  in two difrent  files names, look easy....but cannot find the way......

 

Thanks a lot,

@pierremile2008 

Depends on which version of Excel you are formulae could be

image.png

Please check in attached file.

Thanks Sergian, works with 3 rd option, many thanks.....how to lern more about the formulas ??
You actually save me a lot of time, i spend hours in ordering 800 refernces coming from different sources, thanks again !!

@pierremile2008 , you are welcome.

INDEX/MATCH technique is explained here How to use INDEX and MATCH | Exceljet