This functionality using INDEX / MATCH would be most excellent in reducing the amount of time I spend manipulating an Excel file.
I entered the formula and data exactly as shown in the example, and I can't get it to work. I hope it isn't some nerd playing a practical joke on me. The only thing that looks weird to me are the outside brackets. I've never seen those used in a formula before.
I entered the formula and data exactly as shown in the example, and I can't get it to work. I hope it isn't some nerd playing a practical joke on me. The only thing that looks weird to me are the outside brackets. I've never seen those used in a formula before.