Thread
:
vlookups
View Single Post
#
4
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
vlookups
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
--
AP
"T" a écrit dans le message de news:
...
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
Reply With Quote