Notifications
Clear all
Topic starter
Hi,
I am looking to auto populate a cell based on a Range.
E.g. Range
0-2,000 = 0.5 Hours
2,001-5,000 = 1 Hour
5,001-8,000 = 1.5 Hour
So if I Populate Cell I3 with 2,500 Cell J3 will automatically Populate 1 hour.
Hoping someone can help 🙂
Christine
Posted : 27/01/2017 8:01 pm
Hi Christine
You can just use a VLOOKUP.
Refer example attached.
Sunny
Posted : 27/01/2017 9:31 pm
