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.
=XLOOKUP(pom,column_pom,column_p)+XLOOKUP(htm,column_htm,column_h)