Mr_Molesely
New Member
- Joined
- Nov 18, 2021
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hello! Hope somebody can kindly help
I have a charging table e.g.
I want to be able to put a input cell where I can enter number of items e.g. 8 which will then lookup column 1 and then give me the associated charge (here it will be 6-19 items so £6.30)
Is there an elegant method to to work this out? I can tweak the format of the No of Items column but I cannot split into separate columns.
Thanks,
Moley
I have a charging table e.g.
No of items | Charge |
1-5 | £2.50 |
6-19 | £6.30 |
20-45 | £9.99 |
I want to be able to put a input cell where I can enter number of items e.g. 8 which will then lookup column 1 and then give me the associated charge (here it will be 6-19 items so £6.30)
Is there an elegant method to to work this out? I can tweak the format of the No of Items column but I cannot split into separate columns.
Thanks,
Moley