Trying to make (what I thought should be quite simple) a spreadsheet with all the separate cell references of the word "Type" in all the worksheets in a file (so eg. Household Number 1, Household Number 3, etc.)
I have been playing around with trying Find, Search, Match - =MATCH("Type", INDIRECT("Household Number "&A2&"'!$C:$C"), 0) - -- this being my last effort.
Any help would be greatly appreciated.
G
Bookmarks