Forum Discussion
Can you use table structured references with a 3D reference Same column through multiple tables.
Hi All, I'm using Windows 10 home ver 20H2, 64 bit Op sys, build 19042.1052, with Excel ver 365. I want to know if its possible to use a 3D reference in a structured reference formula. I have o...
you can do a data consolidate to make one big table00 for table01:table20, then do a search on table00