Hello,
New user, first post so sorry if I've not yet got the hang of formatting in this forum.
I have three lists, lets use a simpler example than mine (mine have 30 or so rows each)...
LIST1
House 0.2
Car 0.5
LIST2
UK 1
USA 2
LIST3
Red 10
Blue 5
I want
House UK Red 2 ( being 0.2 * 1 * 10)
House UK Blue 1 ( being 0.2 * 1 * 5)
House USA Red 4 (0.4 * 2 * 10)
House UK Blue 2
etc etc
Any ideas how I could do this in Excel. I sometimes have four lists but size(list1) * size (list2) * ... size(listn) is always reasonable, i.e. <100,000
I don't have power query as I'm on 365 at home
Thanks
Rob
Bookmarks