conditional function questions

Copper Contributor

I am trying to create an invoice form that will allow my employer to input a number (1,2,3,4) and the charge for the occupancy amount will generate automatically.

I have created a reference page with the amounts on it. how do i create the conditional format?

2 Replies
Some more information is needed to give you the actual formula but here is the form factors you can use/try:
=VLOOKUP( [input number cell location], [reference page table reference], [column with value ])
you could also use XLOOKUP, or a LOOKUP or HLOOKUP if the data is horizontal.
If you attach or give link to a sample sheet we could help you more.


It might be no more than

= INDEX(occupancyAmount, number)