https://docs.google.com/spreadsheets...it?usp=sharing
=LOOKUP(2,1/(TEXT(E$1:E,"#####")=TEXT(A1,"#####")),F$1:F)
I'm using this formula to try and find the last occurrence of a value within the E column and return the adjacent value from the F column. I'm trying to force the criteria to search using a text format. It doesn't seem to want to work.
Bookmarks