Vlookup or Index to return furthest right column of data

Hello, I attached a sample excel file to help explain my problem.

In the "Formula" sheet, the vlookup function I have is working as it should, but I'd like to change it so the formula works for the column whose date matches today's date in the "Date" sheet. So the formula should work automatically every day for today's column date.

Thanks!

Hello
Try with the Match function inserted in your Vlookup for the column reference:

Please Login or Register  to view this content.

Hope this helps.
DBY

That worked, thanks!