Forum Discussion
Referencing Entire Workbook
I am working to have a cell that includes all of the sheet names in a workbook that a certain value is present. For example, value=8,456; tabs where value is present B3 and C1; cell reads: B3, C1 My ...
Hi Matt,
Nope, CONCATENATE doesn't work with arrays/ranges. That do TEXTJOIN and CONCAT, but both are for Office 365 subscribers.
There were a lot of custom functions in VBA, code is easy to find, which do approximately the same as latest two functions. But if use macro, in your case it will be more effective to write the function which directly solves your tasks.
Back to your file, that could be straightforward and not very flexible solution to use the combination of IF which checks sheet by sheet. That is in attached file. Here is also the LOOKUP solution, but it returns only first found sheet.
Sergei you are a wizard. Cannot thank you enough for all the help!!