close

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 would be appreciated.--
wingale
------------------------------------------------------------------------
wingale's Profile: www.excelforum.com/member.php...oamp;userid=33467
View this thread: www.excelforum.com/showthread...hreadid=532713

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()