Forum Discussion
Trying to cross reference data when there isn't a table, Vlookup unsuitable
Hi, due to the nature of the information required, one of the sheets isn't a table, but a set of merged cells etc. I am aware that I have to unmerge cells to do the formula, and then merge them a...
Hi ShearaKLC,
You are trying to create a list based on criteria. Here is a link to an article that explains how to do that. I've used it lots myself. It's a little complicated, but it works great. Hope you get it to work for you!
https://chandoo.org/wp/2011/11/18/formula-forensics-003/
Dominique