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.
Hi Hans,
I have found out that I have Excel for Mac 2019. Does this change anything?
I have found out that I have Excel for Mac 2019. Does this change anything?
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.
- OMG! IT WORKED!!!!
Thank you so so much Hans. Really. Thank you for your patience and diligence!