Forum Discussion
sum of two drop down lists
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.
In that case, I don't understand why it doesn't work for you, sorry. The result of the formula changes when I select different items from the drop downs in columns B and C.
I have found out that I have Excel for Mac 2019. Does this change anything?
- OMG! IT WORKED!!!!
Thank you so so much Hans. Really. Thank you for your patience and diligence! 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.