I need to link 2 columns in excel so that when I select a value from the drop down list in the first column it automatically populates the empty cell in the second column from a lookup table.
Example:I’m trying to put together a worksheet that allows the user to select how many of product pumps they’re selling (1-60) from a drop down list which then correlates to a lookup table with the consumable values on it so that it automatically populates the cell. Eg. 1 Product Pump =£3,500, if I select 4 Product pumps from the drop down it automatically populates the cell with £14,000 on so on up to 60 Product Pumps = £210,000
It will only let me insert an image not a file, is there an email address?
I have had another colleague of yours respond, so it confused me
Please, I would like to continue working with Jess
Yes I have downloaded the file and it's great. I have sent you 3 other messages regarding it though? I also wanted the formula so I can learn to do the same and replicate if need be
Yes thanks - the other 3 messages I sent where via your profile link as your colleague kept replying so I couldn't respond directly to you
It's ok. I just needed to know what formula you used so I learn from what you did
no it's fine thank you