vlookups

T

T

Hey

My problem is such.

I have two seperate spreadsheets. The first one has a list of reference
numbers with a value relating to it. In the second one I had the same list of
numbers but not in the same order as the first and with different values
related to it. What I need is the value from the first sheet to appear next
to the same number as the first sheet but in the second sheet.

I hope that makes sense
Please Let Me Know

T
 
G

Gazeta

U¿ytkownik "T said:
Hey

My problem is such.

I have two seperate spreadsheets. The first one has a list of reference
numbers with a value relating to it. In the second one I had the same list of
numbers but not in the same order as the first and with different values
related to it. What I need is the value from the first sheet to appear next
to the same number as the first sheet but in the second sheet.

I hope that makes sense
Please Let Me Know

T
Click to expand...

vlookup should do that
mcg
 
A

Ardus Petus

Assuming data in sheet1 are in columns A and B
idem in sheet2

In sheet2 C1, enter:
=VLOOKUP(A1,Sheet1:A:B,2,0)
and drag down.

HTH
 
D

davesexcel

T said:
Ya i'm aware that vlookups does that. I need to know how to do it usin
vlookup
Click to expand...
[/QUOTE]

Search the newsgroups for VLOOKUP you will get tons of info

use excels "help" and search for vlooku
 
Top