User Profile
feistyb
Copper Contributor
Joined May 05, 2023
User Widgets
Recent Discussions
Re: sum of two drop down lists
Hi Hans, Thank you for responding. I have further questions and will be repeating previous info for clarity. (apologies for redundant information. I am not good with this.) There is a number populating the the desired cell, but the sum is not correct. This is what I did: in cell A2 (which reads 0)- the formula I entered is: =IFERROR(XLOOKUP(B13,BL[BL DESCRIPTION],BL[BL'#])+XLOOKUP(C13,BLHTM[HTM DESCRIPTION],BLHTM[HTM'#]),) Cell B2 (where it says FRONT BODY LENGTH) is a drop down list linked to BL description column in ORANGE CHART Cell B3 (where it says HPS to Skirt Overlap) is a drop down list linked to HTM description column in BLUE CHART. You advised : =IFERROR(XLOOKUP(B2, B10:B20, A10:A20)+XLOOKUP(C2, C2:C10, D2:D10), "") I followed the layout, but my data for the charts/drop down lists are located in another sheet. And omitted "". When "" are added, nothing populates. These are my data charts: ORANGE is BL chart BLUE is HTM chart My desired result is to have cell A2 read 101.04 when the formula is correct. Thank you for your time.
