| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to create a formatted 'readable' document based on Excel document? | Excel Discussion (Misc queries) | |||
| how do i rotate a document or print small document on envelope | New Users to Excel | |||
| How to put pictures into an excel document for merging in Word? | Excel Worksheet Functions | |||
| When merging information not merging correctly | Excel Worksheet Functions | |||
| Sorting, Merging, and Re-merging | Excel Worksheet Functions | |||
Linear Mode
