Apr 03 2021 12:08 PM
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
Apr 04 2021 08:19 AM
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.
Apr 04 2021 01:33 PM
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,
Apr 05 2021 01:05 AM
Depends on which version of Excel you are formulae could be
Please check in attached file.
Apr 05 2021 02:28 AM
Apr 05 2021 03:11 AM
Apr 05 2021 06:41 AM
@pierremile2008 , you are welcome.
INDEX/MATCH technique is explained here How to use INDEX and MATCH | Exceljet