LOOKUP

Copper 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