Forum Discussion
finding data across sheets by searching a specific column by name and displaying in a found set
Hi Group if I had a spreadsheet with lots of data on several sheets, I wanted to search from a column in each sheet for results from a range of numbers entered in a search cell. and then display...
It's possible with some 365 functions capable of handling 3D references such as VSTACK and TOCOL, for example. It's difficult to draw up a formula without a sample workbook.