Forum Discussion
Solved
Assigning value to the names in a dropdown list
Hi, Is there anyway to assign values to the elements of a dropdown list? So that when I select an option from the list, it automatically feed the value to the formula? Please see the attached fil...
You may try this...
In G4
=IF(E4="","",IFERROR(VLOOKUP(E4,Table1,2,0),0)*F4)and then copy it down.
You may try this formula on Sheet3
=IF(C6="","",SUMIF(Sheet2!$F$4:$F$10,C6,Sheet2!$H$4:$H$10))Or you may also insert a Pivot Table like one I inserted on Sheet3 in the attached to get the desired output.
Hi,
Thank you very much. It is very helpful.
Best,
Tooba
Thank you very much. It is very helpful.
Best,
Tooba