Thread: Lookup, match?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default 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.