I have a table with groups of four rows: Year, TX, NI, RI; only Year changes. How can I lookup both Year and NI to get Rate?
Code:
=VLOOKUP((IF(MONTH(NOW())<4,YEAR(NOW()),YEAR(NOW())+1)), Table, MATCH("Rate"), Table[#Headers], 0), FALSE)
Last edited: