Forum Discussion
DENNIS92
Dec 01, 2022Copper Contributor
Spreadsheet For Work
Hello All. I have not used Excel for over 20 years and now I find myself stuck. Im basically trying to come up with a function where numbers 1-20 have a dollar value. IE. Cell A name is Zone, That ...
Riny_van_Eekelen
Dec 01, 2022Platinum Contributor
DENNIS92 Easiest would be to create a table with two columns, Zone and Rate. Zone contains all numbers from 1 to 20, and the Rates column the appropriate rate for each zone. Don't bother to group the zones like 2&3 with one rate. That just makes it more complicated.
Then you can use VLOOKUP to find the appropriate rate based on the zone. That formula would something like:
=VLOOKUP(zone, zone_table, 2, FALSE)
Where zone refers to a cell where you want to find the rate for and zone_table refers to the range or table name for the table I described above.
A lot has changed since you last used Excel. So, If you happen to be working in a more recent version now, you might even have the XLOOKUP function at your disposal.