Lookup, match?
Thank you this has been solved!
"jkb66" wrote:
Thank you all that did help part 1 of a 2 part problem!,
same workbook. sheet 3 I have a value in column b that I need to match in
sheet 2 and bring the corresponding value in column b and populate into sheet
3 column d, I had thought I could manipulate these VLookups to suit purpose,
but I keeping getting #REF!
"Stephen" wrote:
"jkb66" wrote in message
...
I have a value in column A on sheet 3, I want it to match a value in column
A
in sheet 1, then I want the corresponding number from column c on sheet 1
to
populate column c on sheet 3.
To get you started, in cell C1 of Sheet3 put this formula:
=VLOOKUP(A1,Sheet1!A1:C999,3,0)
(Adjust the range A1:C999 to suit your data.)
Copy it down as far as you need for data in Sheet 3.
|