Pulling Specific info to transfer to another worksheet

Hello all - I am trying to do something, and not sure that it can be
done..

I have a workbook with two worksheets. Sheet 1 has database info in 3
colums, First, Last & Company. Sheet 2 has different database info in
4 columns. First, Last Company & Email.

Here's what I want to do.

If the first, last & company are identical in both worksheets, then I
want the email address from sheet 2 to go to the appropriate cell in
sheet 1.

Am i asking too much???

Thanks in advance!


---
Message posted from http://www.ExcelForum.com/

Assuming you're using Columns A, B, &C, on both sheets and column D on
sheet 2.............Insert a new column to the left of column A on both
sheets, then in Sheet1 cell A1 put =B1&C1&D1..........this will concatenate
all three columns into one, then copy the formula down as far as you have
data..........then in Sheet1 cell E1 put this formula and copy it down as
far as you have data..........=VLOOKUP(A1,MyRange,5,false)

Then go to Sheet 2 and highlight the entire range of cells you have data in,
and do Insert Name Define and type MyRange in the name window.
OK........

Vaya con Dios,
Chuck, CABGx3



"bleu808 " wrote in message
...
Hello all - I am trying to do something, and not sure that it can be
done..

I have a workbook with two worksheets. Sheet 1 has database info in 3
colums, First, Last & Company. Sheet 2 has different database info in
4 columns. First, Last Company & Email.

Here's what I want to do.

If the first, last & company are identical in both worksheets, then I
want the email address from sheet 2 to go to the appropriate cell in
sheet 1.

Am i asking too much???

Thanks in advance!


---
Message posted from http://www.ExcelForum.com/

bleu,

IF your data is in columns A:C of Sheet1 and in columns A of Sheet2, and
you want to extract the value from column D, then in cell D2 of Sheet2,
array enter (with Ctrl-Shift-Enter) the formula:

=INDEX(Sheet1!D,SUM(IF(Sheet1!A1:A1000=A2,IF(B2= Sheet1!B1:B1000,IF(C2=Shee
t1!C1:C1000,ROW(Sheet1!D11000))))))

Assumes your dataset is less than 1000 rows long on Sheet1. Change that to
match your count of data rows if you have more.

Watch line wrapping: the formula should all be on one line.

HTH,
Bernie
MS Excel MVP


"bleu808 " wrote in message
...
Hello all - I am trying to do something, and not sure that it can be
done..

I have a workbook with two worksheets. Sheet 1 has database info in 3
colums, First, Last & Company. Sheet 2 has different database info in
4 columns. First, Last Company & Email.

Here's what I want to do.

If the first, last & company are identical in both worksheets, then I
want the email address from sheet 2 to go to the appropriate cell in
sheet 1.

Am i asking too much???

Thanks in advance!


---
Message posted from http://www.ExcelForum.com/

Thanks to both of you for your help, but I wasn't able to get either one
to work.


---
Message posted from http://www.ExcelForum.com/

If you would like to send a copy of your workbook to my home addy, (NOT the
newsgroup), I will try to set it up for you........

Vaya con Dios,
Chuck, CABGx3



"bleu808 " wrote in message
...
Thanks to both of you for your help, but I wasn't able to get either one
to work.


---
Message posted from http://www.ExcelForum.com/