Oct 18 2020 11:17 AM
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
Oct 18 2020 11:34 AM
SolutionYou may try this...
In G4
=IF(E4="","",IFERROR(VLOOKUP(E4,Table1,2,0),0)*F4)
and then copy it down.
Oct 18 2020 11:39 AM - edited Oct 18 2020 11:40 AM
@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.
Oct 18 2020 12:18 PM
You're welcome @MTooba! Glad it worked as desired.
Nov 11 2020 03:43 AM
Hi,
Please see the attached file. I am trying to calculate the cost in terms of categories. Is there any way to combine the results of different categories in the final sheet?
Thank you very much for taking the time.
Best regards,
Tooba
Nov 11 2020 09:17 PM
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.
Nov 12 2020 03:58 AM
Dec 16 2020 03:19 AM
Hi @Subodh_Tiwari_sktneer , its me again.
Hope you are doing well.
Please check the attached file. I need to fix the price of one task for all the staff members this time. Can you please have a look if it can be done?
Thank you very much.
Best regards,
Tooba
Oct 18 2020 11:34 AM
SolutionYou may try this...
In G4
=IF(E4="","",IFERROR(VLOOKUP(E4,Table1,2,0),0)*F4)
and then copy it down.