Here you go:



=IF(ISNA(INDEX($B$1:$B$4,SMALL(IF($A$1:$A$4=TODAY( ),ROW($B$1:$B$4)-ROW($B$1)+1),ROWS($B$1:$B1)))),"",INDEX($B$1:$B$4, SMALL(IF($A$1:$A$4=TODAY(),ROW($B$1:$B$4)-ROW($B$1)+1),ROWS($B$1:$B1))))
Where Col B contains the list of cars
Col A the date/s

This is an array formula so confirm this with Ctrl+Shift+Enter

Thanks Marcia for your quick reply

I did what you told me

I pasted the formula in a cell and then I preses Ctrl+Shift+Enter and it gave me the message "the formula you typed contains an error"

Maybe like shown in the attached.

Attached Files

GetText.xlsx (10.6 KB, 9 views)

Xor, I don't think IFERROR works with Excel 2007. And maybe even INDEX MATCH?

I pasted the formula in a cell and then I preses Ctrl+Shift+Enter and it gave me the message "the formula you typed contains an error"[/quote]
There is an error because "today" is Nov 14 and you do not have nov 14 in your data. Insert a cell where you type your reference date, like Xor's table. Replace TODAY() with the cell address of your reference date. Learn to name your table and range, it is very flexible when copying formulas down rows or across columns.
I guess IF ISNA is not applicable with INDEX MATCH function so remove / edit the formula. See the formula in D3 and E3, compare it with D2 and E2.

Attached Files

GetText.xlsx (15.9 KB, 11 views)