Pulling Specific info to transfer to another worksheet

  • Thread starter Thread starter bleu808
  • Start date Start date
B

bleu808

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

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

Here's what I want to do.

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

Am i asking too much???

Thanks in advance
 
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
 
bleu,

IF your data is in columns A:C of Sheet1 and in columns A:D 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:D,SUM(IF(Sheet1!A1:A1000=A2,IF(B2=Sheet1!B1:B1000,IF(C2=Shee
t1!C1:C1000,ROW(Sheet1!D1:D1000))))))

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
 
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
 
Back
Top