Filling a 3rd row, by comparing 2 other rows

larschr

New Member
Joined
Nov 15, 2005
Messages
7
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)
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

larschr

New Member
Joined
Nov 15, 2005
Messages
7
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
 

al_b_cnu

Well-known Member
Joined
Jul 18, 2003
Messages
4,494

ADVERTISEMENT

Hi,

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

larschr

New Member
Joined
Nov 15, 2005
Messages
7
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 ...
 

al_b_cnu

Well-known Member
Joined
Jul 18, 2003
Messages
4,494

ADVERTISEMENT

Over to the International section then :confused:

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

might be worth a try
 

larschr

New Member
Joined
Nov 15, 2005
Messages
7
hmm, i found a description of it;

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

Make any sence ?

Seems the matrix is the problem ..
 

al_b_cnu

Well-known Member
Joined
Jul 18, 2003
Messages
4,494
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 :confused:
 

larschr

New Member
Joined
Nov 15, 2005
Messages
7
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
 

Watch MrExcel Video

Forum statistics

Threads
1,119,136
Messages
5,576,295
Members
412,716
Latest member
Ardin
Top