Attached is an excel file. There are two worksheets. In Worksheet 1
are 2 names with multiple dates and lab values. In Worksheet 2 is the
name with a blank space for labs and dates. I need put in the blank
lab and date fields on worksheet 2 the most recent date with associated
lab value.

Thanks to Steveg on a very similar topic we are using the formula
=SUMPRODUCT(--(Sheet1!$A$1:$A$12198=A1),--(Sheet1!$C$1:$C$12198=B1),(Sheet1!$F$2:$F$12198))
to get a value if there was only one to chose from on seperate
worksheets. The only problem I am having with this formula in my old
case, is that it is not working when the values are textual.

Thanks for the help,
Wendi


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

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