User Profile
feistyb
Copper Contributor
Joined May 05, 2023
User Widgets
Recent Discussions
- 2.7KViews0likes0Comments
- 2.7KViews0likes5Comments
Re: sum of two drop down lists
HansVogelaar Yes, please see attached. Tabs/sheets are highlighted in green and red. The data charts are in red "data set(DO NOT USE PRINT)" tab The cells that I want to populate using formula are in green "GRADED SPEC" tab. If there is anything else I can make clearer for you, pls let me know. Again, thank you for your time!2.8KViews0likes11CommentsRe: 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.2.7KViews0likes13Comments
Recent Blog Articles
No content to show