Find the number in a second sheet and search for the latest date
I have to sheets:
In sheet 1, I will show the latest date for a special "string". This date I need to search in sheet 2.
See picture below.
In sheet 1: For the number 43KA123456 it gives me back the latest date from sheet 2 for that number. If the number is not found, it gives me back "not found".
Sheet 1 has approx 10000 lines and sheet 2 approx 8000 lines.
I try it with =MAX(Collect()), but this doen´t work. But it could also have been a syntax problem.
Do you have an good idea how to handle this.
Help Article Resources
Check out the Formula Handbook template!