Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
169
Views
Topic starter
Hello,
I am using this formula in Cell(C5) to look through the Date column(A) for the last entry date.
=IFERROR(LOOKUP(10^99,A:A),"None")
I am looking to see how to modify the formula above or what other possible formula I can use to scan:
Column G for 6-Month Review and Place the Date of this 6-Month Review into Cell(D6) Last 6-Month Review
Any help would be greatly appreciated.
Posted : 13/02/2024 4:00 pm
=INDEX(A:A,match("6-Month Review",G:G,0))
should do it.
Posted : 13/02/2024 7:35 pm
Topic starter
Hello Velouria,
That worked. Thank you.
Have a great day!
Posted : 21/02/2024 9:02 am
