View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JW[_2_] JW[_2_] is offline
external usenet poster
 
Posts: 638
Default Merging Document Help

On Sep 24, 5:14 pm, DeperateNumbers
wrote:
I have a number in column B of Worksheet A. I'm trying to locate that same
number from Worksheet B, column A. Once I have found corresponding numbers,
I want to pull the information from column C, Worksheet B into Column C
Worksheet A. And then repeat for mulitple rows. Can you please help?


In cell C2 of Worksheet A, place this and paste down as needed.
=VLOOKUP(A2,'Worksheet B'!A:C,3,FALSE)