Hi
ive got a spreadsheet and ive used data validation to look at a list on another tab.
i need to be able to multiply values out based on what i choose on the drop down menu
ive attached a sample spreadsheet to help explain
thanks
Hi
ive got a spreadsheet and ive used data validation to look at a list on another tab.
i need to be able to multiply values out based on what i choose on the drop down menu
ive attached a sample spreadsheet to help explain
thanks
hello try this in c2
=IF($A2="","",VLOOKUP($A2,Sheet2!$A$1:$B$5,2,0)*$B2)
and drag down
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
thanks hemesh, works a treat!
Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks