Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combinging two spreadsheets
I am trying to combine two spreadsheets into one spreadsheet. If the items in
a column on both spreadsheets match I want a third column on the first spreadsheet to automatically input a value from the second spreadsheet. Spreadsheet #1 Spreadsheet #2 A111 A111 P A114 A124 S A222 A222 O Match = Spreadsheet #1 A111 P A222 O |
#2
|
|||
|
|||
Bruce,
Sounds like a Vlookup formula, have a look at this web site or search here for examples of which there are many. HTH http://www.ozgrid.com/Excel/excel-vlookup-formula.htm "Bruce" wrote in message ... I am trying to combine two spreadsheets into one spreadsheet. If the items in a column on both spreadsheets match I want a third column on the first spreadsheet to automatically input a value from the second spreadsheet. Spreadsheet #1 Spreadsheet #2 A111 A111 P A114 A124 S A222 A222 O Match = Spreadsheet #1 A111 P A222 O |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with link cells between 2 spreadsheets | Excel Discussion (Misc queries) | |||
Linking between spreadsheets does not work unless I have both spr. | Excel Discussion (Misc queries) | |||
Compare two spreadsheets to find differences. | Excel Discussion (Misc queries) | |||
Two spreadsheets linked - moving cells | Excel Discussion (Misc queries) | |||
How do I get my actuarial spreadsheets to comply with SOx? | Excel Discussion (Misc queries) |