Forum Discussion
Help with VLOOKUP
I am doing a new spare parts list in 3 different language and therefore i need to combine info from two Taps in excel.
In tap1 i have my part numbers in column A, and I need to add my English text in Column B, German in Column C and French in column D which i have in Tap 2.
My problem is that my part numbers i tap 2, is located 3 times - one for each language.
I could use a (for me) simple vlookup and solve this normally like this:
=VLOOKUP(A:A;Tekst!A:C;3;FALSE)
But in this situation i need to combine the search for parts numbers in column A with the language code in Column B, to give me the correct output text from Column C in TAP 1.
Hope i did not complicate it too much...
How do i do this ?
Any solutions ?
Your help is much appreciated.
I have attached my excel document and pictures here.
Hi Peter,
No VLOOKUP there!
You have to use the powerful INDEX/MATCH!
This is the formula:
=INDEX(Tekst!$C$2:$C$16276,INDEX(MATCH($A2&LEFT(B$1,3),Tekst!$A$2:$A$16276&Tekst!$B$2:$B$16276,0),))
Please find it in the attached file.
Hi Peter,
No VLOOKUP there!
You have to use the powerful INDEX/MATCH!
This is the formula:
=INDEX(Tekst!$C$2:$C$16276,INDEX(MATCH($A2&LEFT(B$1,3),Tekst!$A$2:$A$16276&Tekst!$B$2:$B$16276,0),))
Please find it in the attached file.
Hi Haytham,
Thank you very much - This save me a lot of time in the future.
