Forum Discussion
Excel Dates lookup
I am currently working on a small project where a user inputs hours in a simple form. The hours and the date are stored in a simple list in Columns A (hrs) B (Date). A lookup list of dates are in Col...
Thanks for your reply so MATCH is not, in this case, a good solution. I didnt want anything complicated!
paulturner Perhaps you need to go with VLOOKUP or XLOOKUP if you are on a recent Excel version.