**Formula in Excel to display the date for the last occurrence of a value in a table**
Hello,

This is a follow-up question to the above thread. The formula given (by

**Flyster**) for the solution was:

=LOOKUP(2,1/(B1:B12=B15),A

1:A12)

My question in __this__ thread relates to the denominator of the 2nd term which includes the following:

B1:B12=B15

**How can a **__range__ of values be equal to a __single__ value?

A range of cells implies multiple values, right? So I understand when a range is part of a function — such as:

a) entering the formula =SUM(B1:B12) in cell B15 or

b) asking if the function of a range is equal to the value in a single cell: =IF(SUM(B1:B12)=B15,1,0)

**But what does it mean to put a range of values equal to a single value?**

Thanks