Use of Indirect on two worksheets
 

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 |
+-------------------------------------------------------------------+

--
wgechter
------------------------------------------------------------------------
wgechter's Profile: http://www.excelforum.com/member.php...o&userid=30799
View this thread: http://www.excelforum.com/showthread...hreadid=504606

Use of Indirect on two worksheets
 

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


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=504606

Use of Indirect on two worksheets
 

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


--
wgechter
------------------------------------------------------------------------
wgechter's Profile: http://www.excelforum.com/member.php...o&userid=30799
View this thread: http://www.excelforum.com/showthread...hreadid=504606

Use of Indirect on two worksheets
 

Wendi,

Glad it was the right solution for you.

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=504606