You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I am looking to do a dropdown menu (like I have down below) and that when they select an item from the list that a number will calculate in the column right beside based on which item they selected from the dropdown menu. Anyone have any insight?
MacBook Air 13″, macOS 14.4
I am wanting there to be a drop down where they can select an item and then the cost of that item will appear automatically in the column beside it. I tried to google XLOOKUP and I'm still not completely grasping this.
What is to be calculated? Typically you would have another table that has data for each type of box (box name in column A, price or size or something in column B, and other data in the other columns) and would use XLOOKUP to look up a value from that table.
Assuming in your first post that the pop up menus are in column A of that table,
=XLOOKUP(A,Table 1::A,Table 1::B,"",0)
Numbers Dropdown Menu
