conditional function questions

[shellyvanweelden]

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]

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.

[#3]

@shellyvanweelden 

It might be no more than

= INDEX(occupancyAmount, number)