Excel flow

[Xeryar]

.  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 corresponding  consumables (called Pack & ship in this file) they can sell with the durable product

[#2]

@Xeryar 

See the attached version.

[#3]

Hi hans its not working for me also I thought if I select the item# it will give me accompanying dispener

[#4]

@Xeryar 

In what way doesn't it work? Do you see #NAME! ?

[#5]

The drop down is not working for me and I thought the drop down will be item number and it will show the description and accompanying dispensers

[#6]

@Xeryar 

That's not how I interpreted your original question. I'll take a look later.

[#7]

@Xeryar 

Can you explain more clearly what you want?

[#8]

@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

[#9]

@Xeryar 

I can't help you with that, sorry.

[#10]

if not the other way around is it possible to set it where if I select the item number I get the accompanying dispenser

[#11]

@Xeryar 

Yes - see the attached version.

[#12]

it is showing me #NAME?
regardless of what I select

[#13]

@Xeryar 

The formulas I used work in Excel in Microsoft 365 and Office 2021, and in the browser.

Which version do you have?

[#14]

@HansVogelaar i have office standard 2019 do i need to do something on my end for it to work 

[#15 · Accepted solution]

@Xeryar 

Here is a workbook that should work in all versions of Excel from 2007 on,