Auto populate a cell with a price
Hi folks I’m guessing I use the lookup function for this but I want to do a drop down arrow for items and have it auto populate a cell with the price for that item. So for example hoodies cost $5.99 and hats cost $3.99. I want to have column a show that item based on a drop down menu that would display the item hoodie or hat, and I want the column b to display the price of the item, $5.99 or 3.99 in this example. Any suggestions please and thanks
|