| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match 2 fields in 2 seperate Spreadsheets and fill another column
Greetings,
Here is what I am trying to do... *NOVICE Here* I have a workbook that has multiple spreadsheets with various data on them. I want to "Match" Data in one column A on spreadsheet 1 to column B in spreadsheet 2 and then fill data from column C on spreadsheet 1 to column D on spreadsheet 2 if Column A & B match... I am having a dickens of a time trying to do this... Any help is much apprecaited. -- --Coyote-- |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Match 2 fields in 2 seperate Spreadsheets and fill another column
In D1 of sheet 2:
=IF(ISNUMBER(MATCH(B1,'Sheet 1'!A:A,0),VLOOKUP(B1,'Sheet 1'!A:C,3,),"") -- Best Regards, Luke M "pawcoyote" wrote in message ... Greetings, Here is what I am trying to do... *NOVICE Here* I have a workbook that has multiple spreadsheets with various data on them. I want to "Match" Data in one column A on spreadsheet 1 to column B in spreadsheet 2 and then fill data from column C on spreadsheet 1 to column D on spreadsheet 2 if Column A & B match... I am having a dickens of a time trying to do this... Any help is much apprecaited. -- --Coyote-- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Fill Cells With Formula; Conditional To Seperate Column | Excel Discussion (Misc queries) | |||
| Find partial match from column A,B and fill partial match in C? | Excel Discussion (Misc queries) | |||
| Separating text into seperate fields | Excel Worksheet Functions | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| need funct to match data in 3 seperate spreadsheets column 1 to v. | Excel Discussion (Misc queries) | |||
Linear Mode
