Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merge database or sort?
I don't know if there is a way to do this but if anyone can tell me, it would
save me days of work. I have 2 sheets, one with many columns of numbers but one column with identifier numbers (Sheet 1, column a) and anotehr sheet with with 2 columns of #'s (sheet 2, column b and c). Column A and Column B both contain common identifier #'s (column B only has 1500 of 3000 total while Column A has all 3000). What I want to do is merge sheet 1 and 2 with the Sheet 2 two identifier #'s matching positions (i.e. row) with the Sheet 1 identifier #'s. Otherwise i will have to manually move data for 1300 cells from sheet 2 to sheet one. Doable but tedious. Any shortcuts? Thanks anand |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merge database or sort?
Can I ask you to describe it in slightly different fashion? As usual, I'm
having trouble visualizing the whole thing. Perhaps like this: I wish to copy information from sheet 1, columns x, y, z. to sheet 2, columns q, r, s when value in column A on sheet 2 matches column B on sheet 1. or I wish to copy information from sheet 1, columns x, y, z. to sheet 2, columns q, r, s when value in column A or B on sheet 2 matches column B on sheet 1. "anand" wrote: I don't know if there is a way to do this but if anyone can tell me, it would save me days of work. I have 2 sheets, one with many columns of numbers but one column with identifier numbers (Sheet 1, column a) and anotehr sheet with with 2 columns of #'s (sheet 2, column b and c). Column A and Column B both contain common identifier #'s (column B only has 1500 of 3000 total while Column A has all 3000). What I want to do is merge sheet 1 and 2 with the Sheet 2 two identifier #'s matching positions (i.e. row) with the Sheet 1 identifier #'s. Otherwise i will have to manually move data for 1300 cells from sheet 2 to sheet one. Doable but tedious. Any shortcuts? Thanks anand |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merge database or sort?
Hi I think you need to use the Vlookup function make sure the #'s in sheet2 is sorted asc If you have trouble figuring out the Vlookup function let me know i will show you how thanks "anand" wrote: I don't know if there is a way to do this but if anyone can tell me, it would save me days of work. I have 2 sheets, one with many columns of numbers but one column with identifier numbers (Sheet 1, column a) and anotehr sheet with with 2 columns of #'s (sheet 2, column b and c). Column A and Column B both contain common identifier #'s (column B only has 1500 of 3000 total while Column A has all 3000). What I want to do is merge sheet 1 and 2 with the Sheet 2 two identifier #'s matching positions (i.e. row) with the Sheet 1 identifier #'s. Otherwise i will have to manually move data for 1300 cells from sheet 2 to sheet one. Doable but tedious. Any shortcuts? Thanks anand |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merge database or sort?
I agree, it sounds like a VLOOKUP() will work, I'm just a bit confused on
what to use for matching and what columns from where should be returned. "CmK" wrote: Hi I think you need to use the Vlookup function make sure the #'s in sheet2 is sorted asc If you have trouble figuring out the Vlookup function let me know i will show you how thanks "anand" wrote: I don't know if there is a way to do this but if anyone can tell me, it would save me days of work. I have 2 sheets, one with many columns of numbers but one column with identifier numbers (Sheet 1, column a) and anotehr sheet with with 2 columns of #'s (sheet 2, column b and c). Column A and Column B both contain common identifier #'s (column B only has 1500 of 3000 total while Column A has all 3000). What I want to do is merge sheet 1 and 2 with the Sheet 2 two identifier #'s matching positions (i.e. row) with the Sheet 1 identifier #'s. Otherwise i will have to manually move data for 1300 cells from sheet 2 to sheet one. Doable but tedious. Any shortcuts? Thanks anand |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merge database or sort?
I guess the two identifers # in both sheets
"JLatham" wrote: I agree, it sounds like a VLOOKUP() will work, I'm just a bit confused on what to use for matching and what columns from where should be returned. "CmK" wrote: Hi I think you need to use the Vlookup function make sure the #'s in sheet2 is sorted asc If you have trouble figuring out the Vlookup function let me know i will show you how thanks "anand" wrote: I don't know if there is a way to do this but if anyone can tell me, it would save me days of work. I have 2 sheets, one with many columns of numbers but one column with identifier numbers (Sheet 1, column a) and anotehr sheet with with 2 columns of #'s (sheet 2, column b and c). Column A and Column B both contain common identifier #'s (column B only has 1500 of 3000 total while Column A has all 3000). What I want to do is merge sheet 1 and 2 with the Sheet 2 two identifier #'s matching positions (i.e. row) with the Sheet 1 identifier #'s. Otherwise i will have to manually move data for 1300 cells from sheet 2 to sheet one. Doable but tedious. Any shortcuts? Thanks anand |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
merge database or sort?
OK, let's try this.
There is data in column A, C and D. I want a formula to place into a cell in column B. If the value in column A (call it "x") matches any value in Column C (eg. range $c$2:$c$1300), then insert value from column D into cell in column B. For example, we're putting the formula in B3. In A3 the value is 222. The formula in B3 would look for any value of 222 in C2:C1300 and return the value to the immediate right of the match. So if the match is found in C888 and the value in D888 is 911, then B3 should return 911. If there is no value in that position, it should just return a blank. There will be only one match maximum between values in Column A and C. some values in D will be blank. "JLatham" wrote: Can I ask you to describe it in slightly different fashion? As usual, I'm having trouble visualizing the whole thing. Perhaps like this: I wish to copy information from sheet 1, columns x, y, z. to sheet 2, columns q, r, s when value in column A on sheet 2 matches column B on sheet 1. or I wish to copy information from sheet 1, columns x, y, z. to sheet 2, columns q, r, s when value in column A or B on sheet 2 matches column B on sheet 1. "anand" wrote: I don't know if there is a way to do this but if anyone can tell me, it would save me days of work. I have 2 sheets, one with many columns of numbers but one column with identifier numbers (Sheet 1, column a) and anotehr sheet with with 2 columns of #'s (sheet 2, column b and c). Column A and Column B both contain common identifier #'s (column B only has 1500 of 3000 total while Column A has all 3000). What I want to do is merge sheet 1 and 2 with the Sheet 2 two identifier #'s matching positions (i.e. row) with the Sheet 1 identifier #'s. Otherwise i will have to manually move data for 1300 cells from sheet 2 to sheet one. Doable but tedious. Any shortcuts? Thanks anand |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problems using Excel as a mail merge database in Office XP | Excel Worksheet Functions | |||
Merge two spreadsheets with names database then search for duplica | Excel Discussion (Misc queries) | |||
Sort a database | Excel Discussion (Misc queries) | |||
Can I create a database to merge an organizational chart | Excel Discussion (Misc queries) | |||
Excel database - merge to Word | Excel Worksheet Functions |