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

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

One way via index/match

In Sheet1,
Assuming data starts in row 2 down
Put in V2:
=IF(ISNA(MATCH($A2,Sheet2!$A:$A,0)),"",INDEX(Sheet 2!C:C,MATCH($A2,Sheet2!$A:$A,0)))
Copy across to AA2, fill down as far as required. Unmatched cases will
return blanks: "".
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

You need 2 lookups

This in V1 of sheet 1
=VLOOKUP(A1,Sheet2!$A$1:$C$30,3,FALSE)

This in Colmn AA fo sheet 1
=VLOOKUP(A1,Sheet2!$A$1:$H$30,8,FALSE)

Mike
"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

Max,
This works perfectly. Thanks so much.
CB

"Max" wrote:

One way via index/match

In Sheet1,
Assuming data starts in row 2 down
Put in V2:
=IF(ISNA(MATCH($A2,Sheet2!$A:$A,0)),"",INDEX(Sheet 2!C:C,MATCH($A2,Sheet2!$A:$A,0)))
Copy across to AA2, fill down as far as required. Unmatched cases will
return blanks: "".
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

Pleased to hear that. You're welcome.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"CB" wrote in message
...
Max,
This works perfectly. Thanks so much.
CB