Lookup, match?
"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.
|