Trying to automatically populate text when a drop-down option is selected

[marebear2410]

Hello! I am working on making a budget form that lists prices depending on what item is selected. I have the drop-down menu created using data validation and I want the corresponding price to appear in an adjacent box once the item is selected. For example, if they select "microphone" from the drop-down, "$40.00" should appear in the next box over. Any help is appreciated!

[Cutter]

Hello marebear2410, and welcome to the forum.

The usual method would be to have a table somewhere in the file listing the items along with their associated prices. Then you would use a VLOOKUP() to retrieve that price.

Here's a link for that function: http://www.excelfunctions.net/ExcelVlookup.html

If there are only a few items involved there wouldn't be a need for a table and you could use LOOKUP() instead. You'll have to provide more info to get a better answer.