Use of Indirect on two worksheets

[wgechter]

Hello, I have two worksheets in one file. It is attached. What I am
trying to do is insert a value from Sheet 1 on Sheet 2 if the last name
and dob match from Sheet 1. I have a formula on Sheet2 but I know it's
incorrect. I'm not sure how it should work. Thanks for any help,
Wendi


+-------------------------------------------------------------------+
|Filename: Forum help.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4262 |
+-------------------------------------------------------------------+

 

[SteveG]

Wendi,

Based on your column headings in sheet 2 I assume that indicates the
value you are trying to pull from sheet 1. You could use this without
the INDIRECT to get the Lvalue.

=SUMPRODUCT(--(Sheet1!$B$2:$B$3=B2),--(Sheet1!$C$2:$C$3=C2),(Sheet1!$D$2:$D$3))

Does that help?

Steve

 

[wgechter]

Steve,
That works perfectly!! Thanks so much. 2 days research summed up in a
few minutes. Thanks again, Wendi

 

[SteveG]

Wendi,

Glad it was the right solution for you.

Cheers,

Steve