Forum Discussion
Fill up a cell from / according another cell data
Hello,
I'm struggling with an excel sheet I've created and I hope someone will be able to help me...
I have 2 columns:
ITEMS - PRICE
I have a drop down menu for my items and I would like the price's column to be filled up automatically when I select the item.
ie:
ITEM - PRICE
Gloves - 20
Jacket - 90
etc.
I thought about the IF bu I think this is to compare data right? I have a list of 10/15items so as many prices to match.
Many thanks for your help!
It looks like XLOOKUP or INDEX/MATCH or like shall work, but better to have sample file.
5 Replies
It looks like XLOOKUP or INDEX/MATCH or like shall work, but better to have sample file.
Hi SergeiBaklan !
Thank you for your swift reply, I've attached a draft of the sheet here for a better understanding
I've noted manually the prices but I would like my prices to go automatically when I select my item.
For example XL bag = 25 ; Classic = 15; Purse = 10 etc.
Many thanks for your help!
If define prices in the table somewhere in the file
price could be taken by
=IFNA(INDEX(tblPrice[Price],MATCH(C6,tblPrice[Item],0)),"")
