Merging Document Help
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? |
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) |
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) |
Merging Document Help
It won't really transfer all information just the first occurrence unless
the numbers are all unique -- Regards, Peo Sjoblom "JW" wrote in message oups.com... 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) |
All times are GMT +1. The time now is 08:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com