I found a nifty formula that lookups the last value in a table based on a lookup value. However, I don't quite understand it. It is as follows: =LOOKUP(2,1/(A1:A10=C1),B1:B10)
ID Value 1 40
1 10
2 10
3 10
4 10
1 20
3 10
1 40
What does the first number "2" refer to in the formula. And then what does the rest of the formula do? I'm trying to adapt for a spreadsheet that I have. Thanks.
Bookmarks