In one workbook I need to lookup where the date in a cell (E2) and the value in a cell (B3) are equal to a date and value in a 2 separate columns (date is column C and value is column A) in a different worksheet (same workbook) and return the value in the corresponding cell in column O

Attached Files

Excel Sample.xlsx (17.5 KB, 13 views)

Try:

=SUMIFS(Driving_Style[[Distance Travelled (km)]:[Distance Travelled (km)]],Driving_Style[[Registration]:[Registration]],$B3,Driving_Style[[Date]:[Date]],E$2)

copied down and across

Thank you so much! This seems to have done it