Hi,
I have the following formula;
=IFERROR(INDEX('Clinical-Treatments'!$P$12:$P$312,MATCH($D30,'Clinical-Treatments'!$M$12:$M$312,MATCH($L30,'Clinical-Treatments'!$D$12:$D$312,0))),"")
P12:P312 are text values
M12:M312 are numbers
D12:D312 are dates
The formula is returning a match for the 1st date found so it is not matching both the date & the number.
Any ideas on a solution ??
I have the following formula;
=IFERROR(INDEX('Clinical-Treatments'!$P$12:$P$312,MATCH($D30,'Clinical-Treatments'!$M$12:$M$312,MATCH($L30,'Clinical-Treatments'!$D$12:$D$312,0))),"")
P12:P312 are text values
M12:M312 are numbers
D12:D312 are dates
The formula is returning a match for the 1st date found so it is not matching both the date & the number.
Any ideas on a solution ??