Thread: Formula to get text from multiple cells in Excel 2007
View Single Post
 
Old 11-13-2018, 03:28 AM
staicumihai staicumihai is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
  
Join Date: Dec 2015
Posts: 33
staicumihai is on a distinguished road
Default Formula to get text from multiple cells in Excel 2007
Hi guys

I have a table in excel 2007 and one of the columns is with dates

I need a formula to lookup the current day (today) in those columns and for every time it finds a match to get the text from a cell on that line.

For example if I have the table below

BMW 11.11.2018 Opel 11.11.2018 Audi 13.11.2018 Skoda 13.11.2018
Lets say the today date is 13.11.2018
I need the result in a cell to be

Audi
Skoda

Any ideas ?
Thanks
Reply With Quote