I have a spreadsheet where I track expenses.
Over time mileage rates, etc. change
I could manually enter an updated rate after each change, but I'd like to do it with a lookup process
Attached is a copy of the spreadsheet - The value I want as the lookup result is on the Expense Tracking Tab - "Rate" and the table I want to use as the source is the mileage lookup tab
Does anybody know of an existing formula / calc that does type of lookup?