I know it’s possible to do this, just not sure how:
I want to create a page with a drop-down list where I select a service I provide and it automatically populates the next cell over with a price. I’m not sure what I’m missing here.
I know it’s possible to do this, just not sure how:
I want to create a page with a drop-down list where I select a service I provide and it automatically populates the next cell over with a price. I’m not sure what I’m missing here.
Assuming you have a table of services followed by prices such as:
Services Prices
Simple Answer $25.00
Difficult Answer $50.00
Impossible Answer $75.00
Name the cells containing the services
Name the cells containing the services and the prices
On the page where you want the “form”
in the cell for service selection Menu>Data>Validity> Allow- select “Cell Range” select Source name-of-services OK
In the adjacent cell where you want the price, a simple vlookup formula
=vlookup(servicecell,name-of-table-of-services-and-prices,2,0)
Best Regards,
Jim Smith