I want to get eancodes from sheet 2 in sheet 1, only problem location of prodnr is random so i need to search.
Need som help finding right formula
My orginal file is alot mor complex so i setup a simple example.
I want to get eancodes from sheet 2 in sheet 1, only problem location of prodnr is random so i need to search.
Need som help finding right formula
My orginal file is alot mor complex so i setup a simple example.
Hi
=INDEX($Sheet2.$B$2:$B$100;MATCH(A2;$Sheet2.$A$2:$A$100;0))
Regards
This code gives me #N/A
I understand: Your screenshot shows that the product names are not the same in both sheets (space before the number)
omg. sorry for that and thankyou for the fast and good reply