Calculation

[MAMIBUSSOL]

i have the following data
A B
04/06/2011 757L
05/09/2011 657L
08/04/2010 457L

I use the MAX function to find the highest date, but I need to use the data in column B

so the highest date is 05/09/2011 I need to record the highest code as 657L

this works if B18:B22 has a date within the range

=IF(MAX(B18:B22)=B18,C18,IF(MAX(B18:B22)=B19,C19,IF(MAX(B18:B22)=B20,C20,IF(MAX(B18:B22)=B21,C21,IF(MAX(B18:B22)=B22,C22,"BR")))))

however, when I have no values in B18:B22 I expect to see my cell = "BR", however this doesn't happen

any ideas how to modify to get the desired result

 

[Jonmo1]

Try

=IF(COUNT(B18:B22),INDEX(C18:C22,MATCH(MAX(B18:B22),B18:B22,0)),"BR")