Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data consolidation from Multiple Sheets
Hi All, I have a workbook with two worksheets. Worksheet1 has most of the data I need except for a couple of columns. In worksheet2 I have the data that I am missing from worksheet1 in addition to some other data that exists in both. I would like to start at the first row of data in worksheet1, pick up the key data and locate an exact match in worksheet2, then return some other value from another column but same row from worksheet2 to update worksheet1. I have considered VLOOKUP but am not sure if that is exactly what I need. I have read several threads on the subject but am still not sure. Any help will be appreciated. -- wingale ------------------------------------------------------------------------ wingale's Profile: http://www.excelforum.com/member.php...o&userid=33467 View this thread: http://www.excelforum.com/showthread...hreadid=532961 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data consolidation from Multiple Sheets
You can consider either VLOOKUP or combined INDEX/EQUIV formulas
HTH -- AP "wingale" a écrit dans le message de ... Hi All, I have a workbook with two worksheets. Worksheet1 has most of the data I need except for a couple of columns. In worksheet2 I have the data that I am missing from worksheet1 in addition to some other data that exists in both. I would like to start at the first row of data in worksheet1, pick up the key data and locate an exact match in worksheet2, then return some other value from another column but same row from worksheet2 to update worksheet1. I have considered VLOOKUP but am not sure if that is exactly what I need. I have read several threads on the subject but am still not sure. Any help will be appreciated. -- wingale ------------------------------------------------------------------------ wingale's Profile: http://www.excelforum.com/member.php...o&userid=33467 View this thread: http://www.excelforum.com/showthread...hreadid=532961 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I data sort multiple sheets in Excel that are linked with i | Excel Worksheet Functions | |||
combine data from multiple sheets | Excel Discussion (Misc queries) | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
how do i find data in multiple sheets in excel | Excel Discussion (Misc queries) |