Lookup latest status from database

Hi,

Try this array** formula in B3 and copy across and down:

=INDEX('Training Notes'!$E$2:$E$169,MIN(IF('Training Notes'!$A$2:$A$169=MAX(IF(('Training Notes'!$B$2:$B$169=Overview!$A3)*('Training Notes'!$D$2:$D$169=Overview!B$2),'Training Notes'!$A$2:$A$169)),ROW('Training Notes'!$A$2:$A$169)-MIN(ROW('Training Notes'!$A$2:$A$169))+1)))

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

Regards

hi Adam. how about those which are not there? For eg. Scott D, Tennis. Neil R, Tennis, etc. i put them as blanks. and this is assuming your dates are in ascending order:
=IFERROR(LOOKUP(2,1/(('Training Notes'!$B$2:$B$169=$A3)*('Training Notes'!$D$2:$D$169=B$2)),'Training Notes'!$E$2:$E$169),"")

if not in ascending order, then:

Formula:

Please Login or Register  to view this content.