Tag Info

New answers tagged


The above are very creative solutions, but you don't really need to do anything fancy. Match supports the "*" syntax. So =INDEX(A:A,MATCH("*",B:B,-1)) will get you there:)


If you are using LOOKUP like this to get the last value in column B =LOOKUP(9.99E+307,B:B) ....then you can simply add another column as 3rd argument to return the corresponding cell from that column, i.e. =LOOKUP(9.99E+307,B:B,A:A)

Top 50 recent answers are included