ExcelBanter - Vlookup help

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Vlookup help (https://www.excelbanter.com/excel-programming/388297-vlookup-help.html)

Maggie

Vlookup help

I need help I have a field that I put a date with mm/dd/yy (G15) and
from that field I want to be able to pick the current year to get the
vlookup to work. The vlookup is coming from another sheet with that
is named cpi where I have the year and the rate in two columns. If
anyone could help I would appreciate it.

Dave Miller

Vlookup help

Current Year:
=Year(Now())

Year for "G15"
=Year(G15)

All times are GMT +1. The time now is 07:01 AM.