This is a simplified example of what I have.
I am using the Inventory page to show what items I have in stock. An "X" indicates that I have it. "Exempt" indicates that it's not going to happen.
I would like to pull together an "Order list" on the main page that shows where the blanks are.
Ideally, I would like to have any blank (can be as part of a named range or not) return the column and the row names. Format is not important - can run straight down the page, across, or whatever. So, the blank in B8 would add "Dog Brown" to a cell on the order list. The blanks in C6 and C9 would return "Cat Long Hair" and "Cat Blue" etc.
I've tried a number of things and just can't get there. Any help appreciated.
Thanks!
-lee
Bookmarks