# Filling a 3rd row, by comparing 2 other rows

#### larschr

##### New Member
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)

### Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Hi, Welcome to the board!
Book2
ABCDE
1number 1Descriptionnumber2Description
22Desc 21Desc 1
37Desc 72Desc 2
46Desc 63Desc 3
55Desc 54Desc 4
68Desc 85Desc 5
77Desc 76Desc 6
89Desc 97Desc 7
99Desc 98Desc 8
104Desc 49Desc 9
114Desc 410Desc 10
122Desc 211Desc 11
135Desc 512Desc 12
144Desc 413Desc 13
1514Desc 14
1615Desc 15
1716Desc 16
1817Desc 17
Sheet1

formula in B2 & copied down is =VLOOKUP(A2,D:E,2,FALSE)

Thx alot :D

Ups, sorry, im using excell 2000 here, and i seem to get an error
Is the formula suppose to be the same in my version (excel 2000)?
Verry sorry i didnt put this info in my first post

Stopps at A2,D

Hi,

The posted example should work ok with Excel 2000, Can you post an example of your s/sheet layout?

The layout is exactly like your example :/

However, my excel is in Norwegian. So i have to use another word than vlookup and false. (finn.rad / finn.kolonne and usann)

But the logic is suppose to be the same ...

Over to the International section then

I understand that some Excel versions use semicolon ; rather than comma ,

might be worth a try

hmm, i found a description of it;

=VLOOKUP(search value;matrix;row index;sorted)

Make any sence ?

Seems the matrix is the problem ..

larschr said:
hmm, i found a description of it;

=VLOOKUP(search value;matrix;row index;sorted)

Make any sence ?

Seems the matrix is the problem ..

'row index' suggests that you are using HLOOKUP not VLOOKUP

Sorry, collum index that is.

using =VLOOKUP(A2;D:E;2;FALSE) now gets accepted :D (swaping ; for , worked)

But the output of the formula is #I/T

Replies
4
Views
137
Replies
2
Views
84
Replies
2
Views
79
Replies
0
Views
751
Replies
0
Views
160

1,214,713
Messages
6,121,042
Members
449,006
Latest member
cthorne1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back