Data consolidation from Multiple Sheets

You can consider either VLOOKUP or combined INDEX/EQUIV formulas

HTH
--
AP

"wingale" <[email protected]> a écrit
dans le message de
news:[email protected]...
>
> 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
>