Forum Discussion
Xeryar
Mar 10, 2023Copper Contributor
Excel flow
. I wonder if you are able to take the chart in the “Q1 Focus List Merch” tab and turn it into a simple drop down process so an Inbound agent can easily select the machine and when selected show the...
- Mar 13, 2023
Here is a workbook that should work in all versions of Excel from 2007 on,
Xeryar
Mar 12, 2023Copper Contributor
HansVogelaar What i would love to have is a dropdown that will correspond to accompanying machine dispensor and vice versa .
So if I select wb412546 I will get 244290 and if I select 244290 I will receive wb412546 as the first line shows. hope this clears it up
HansVogelaar
Mar 12, 2023MVP
I can't help you with that, sorry.
- HansVogelaarMar 13, 2023MVP
Here is a workbook that should work in all versions of Excel from 2007 on,
- XeryarMar 13, 2023Copper Contributor
HansVogelaar i have office standard 2019 do i need to do something on my end for it to work
- HansVogelaarMar 12, 2023MVP
The formulas I used work in Excel in Microsoft 365 and Office 2021, and in the browser.
Which version do you have?
- XeryarMar 12, 2023Copper Contributorit is showing me #NAME?
regardless of what I select - HansVogelaarMar 12, 2023MVP
Yes - see the attached version.
- XeryarMar 12, 2023Copper Contributorif not the other way around is it possible to set it where if I select the item number I get the accompanying dispenser