Forum Discussion
Solved
Lookup function
Hi. The function I am looking for is a Lookup function, but I do not get it right. I have given two simplified tables below to explain. I need a function for the Date completed in table 1. Who can he...
Use =INDEX($H$4:$H$15,MATCH(1,($E$4:$E$15=A4)*($F$4:$F$15=B4),0)) and set the number format to the custom format dd-mm-yyyy;;0
Sample workbook attached
Use =INDEX($H$4:$H$15,MATCH(1,($E$4:$E$15=A4)*($F$4:$F$15=B4),0)) and set the number format to the custom format dd-mm-yyyy;;0
Sample workbook attached
HansVogelaar, Thanks!!