I have three columns, Column A has the "lookup value", mulitples, column B the dates of entries, column C the criteria I need returned. The data comes in daily, I need the value in column C of the most recent date, (max), in column B for the value in column A

Hi
please post a sample sheet. Thx

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I need to pull odometer from sheet 2, using Unit # from sheet 1 and Vehicle # from sheet 2, but only the most current date. so one result per vehicle #. sheet two gets data feed live, so sheet one will be updating as new odometer readings come in daily

Attached Files

sample.xlsx (60.7 KB, 10 views)

The attached looks promising

Attached Files

Copy of sample.xlsx (68.9 KB, 10 views)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

thank you. I need to look at this more closely. It looks like it is giving me an error where there shouldn't be.
I will get back to you on it.
Again, thank you