Auto populate a cell with a price

oscarlimerick · #1 10-24-2021, 10:28 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto populate cell with today's date	Phil H	Excel Programming	7	10-18-2017 09:41 AM
Auto populate cell based on certain situations	YW3	Excel	10	05-26-2017 02:02 AM
auto cell populate 2	Stevejd58	Excel	3	08-20-2013 04:23 PM
auto cell populate	Stevejd58	Excel	14	05-13-2013 02:22 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM