Forum Discussion
calling an entire table, depending on the dropdown lists selected.
I'm trying to create something for my place of work, but have hit a slight problem, and have been racking my brain for hours now, but im very out of practise with Excel and hoping someone can help. ...
Forget MAKEARRAY. The easier way to convert a range into a SPILL is like =VSTACK(A1:B10). Done.
ecovonrein For what it's worth, why not just =A1:B10 in E1. That also creates a spilled array. No need for VSTACK either.
- Spot on. Because I am dumb. Mind you, the whole operation (of duplicating a table) is kind-of dumb. But it redeems itself at the point of lookup, I guess.
On that note SGTerry: The MATCH(D:D... might be slow. Excel will prefer when you do D1:Dn, ie limit the span to something meaningful.