Feb 19 2019 01:42 PM - edited Feb 19 2019 01:45 PM
Hi, everyone.
Trying to write a formula that will check a table's first column cell's value and, if it meets a criteria to do one thing and, if it does not meet a criteria, then try that first column's previous cell up (previous row above current one), if it still does not meet the criteria, then keep trying the previous cells up until it finds a cell on that first column that meets the criteria.
Hopefully the image below will make the request a bit more clear:
Additionally, I cannot use either macros or VBA.
Thanks in advance,
Edgar
Feb 19 2019 09:21 PM
SolutionFeb 20 2019 09:33 AM
Hi, @Twifoo
I just did a quick test and this is exactly what I was looking for! LOOKUP is it!
Thank you so much,
Edgar
Feb 19 2019 09:21 PM
Solution