One VLOOKUP cell gives me a column list of returns

SRenner

Yes it didn’t work.

SRenner

Would like access to the sheets?

SRenner

Yes It did not work. Would you like access to the sheets?

Andrée Starå

@SRenner

I saw that Paul answered already and that you are close to a solution it seems.

Let me know if I can help with anything else!

Best, 

Andrée 

Paul Newcome

I found it...

=INDEX({Master Sheet Store # Column}, SMALL(COLLECT({Master Sheet Store Count Column}, {Master Sheet Run Name Column}, [Run Name]$1), [Store Count]@row))

That was my fault. Sorry about that. Give the above a try and see how it works out for you.

SRenner

@Paul Newcome That did it!!!!! Thank you!!! this is a huge step for our planning believe it or not. I can move on to the next phases now that will truly put this all together.

Thank you for all the help and time, it is greatly appreciated!

Thanks

Scott

Paul Newcome

Happy to help! 👍️

Sorry for that initial mix-up, but I'm glad we were able to get it working for you,