I have 2 spreadsheets. 1 is a list of procedures. This list has the
columns id_code, name, date_procedure

The other is a list of test results with the columns id_code,
date_test,result.

How can I use the look up functions (INDEX MATCH for eg) to match
procedures to test results only if the test preceeded the procedure by
<=14 days and =0 days ?

Thank you for your thoughts


--
abehart
------------------------------------------------------------------------
abehart's Profile: http://www.excelforum.com/member.php...o&userid=33482
View this thread: http://www.excelforum.com/showthread...hreadid=532835