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 file.
A solution will be much appreciated.
Best,
Tooba
You may try this...
In G4
=IF(E4="","",IFERROR(VLOOKUP(E4,Table1,2,0),0)*F4)and then copy it down.
7 Replies
You may try this...
In G4
=IF(E4="","",IFERROR(VLOOKUP(E4,Table1,2,0),0)*F4)and then copy it down.
Subodh_Tiwari_sktneer Thank you very much. I think your formula solves my current problem. I might get back to you if there is another problem. Really appreciate your quick response.
You're welcome MTooba! Glad it worked as desired.
