Forum Discussion
Solved
sum of two drop down lists
Hi, I know this questions has probably been asked and answered, but I think I need a more direct answer. Thanks in advance!
Yes, that makes all the difference! XLOOKUP is only available in Microsoft 365 and Office 2021, not in Office 2019.
Try this formula instead:
=IF(B13="",0,INDEX(BL[BL'#],MATCH(B13,BL[BL DESCRIPTION],0)))+IF(C13="",0,INDEX(BLHTM[HTM'#],MATCH(C13,BLHTM[HTM DESCRIPTION],0)))
Workbook with this formula attached.
Does this do what you want?
Unfortunately, no.
I am not able to select other options in the drop down lists and have them sum correctly/without error.
I am not able to select other options in the drop down lists and have them sum correctly/without error.