Filling a 3rd row, by comparing 2 other rows

[larschr]

I have 2 rows with numbers. First row is longer than the second, (several identical numbers)

To the right of the second number row i have a descrition (text) of that number. The numbers in the 2 rows need to get the same description

I need to compare the 2 number rows, and fill in the coresponding text from number row 2 to a new row next to number row 1.


numbers ------ (text need to be inserted) ------ numbers2-----(text that need to be inserted)

 

[al_b_cnu]

My knowledge of Norwegian is zero, but I guess that this is '#N/A' in English, meaning that VLOOKUP couldnt find the lookup value.

 

[larschr]

Yay, works perfectly now :D thx m8