Hi, I have two drop down lists in consecutive columns, with numbers. I want these numbers to multiply together, but i want to pull the answer from a table. Obviously the numbers could change and thus the answer pulled through to the 3rd column. Any help would be greatly appreciated.
Last edited by Amateurlou; 05-22-2020 at 10:22 AM.
Trying to get my head around your needs. Is the drop down in each cell and you want to multiply whatever is in cells A1 * B1? The data in the drop down is pulled from a different list of info. Is that correct?
It would help if you attached an example spreadsheet using the instructions in the yellow banner. Also, update your title to better describe your problem so that it is easily searchable (i.e. "Pulling data dependent on two dropdowns")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks Jack - I have now managed to upload snippets of the excel worksheets in question. So impact multiplied by proximity but I want it to take the answer from the table which is on another tab. The reason I need to do this is some values are in different colours. Thus the simple multiple and then using conditional formatting to highlight won't be sufficient. Thank you
Thanks ChemistB - made those changes!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks