Lookup Question
BTW, I am using Excel 2007.
"CB" wrote:
I have a workbook that has 2 sheets of data. I would like to have sheet 1
column a go to sheet 2 Column A and look for a match (not case sensitive).
When a match is found I need the data in sheet 2 columns C:H copied to the
corrosponding row of column V:AA in sheet 1.
I am new to functions and lookups in Excel. A detailed example would be
most appreciated.
Thanks in advance.
CB
|