Forum Discussion
Solved
another index match?
Source File has: Type, Name, Account Plant File has: Type, Amounts per month MA File has: Name, Account I would like to retrieve Amounts per month from Plant File, but there are no common fe...
Here is a simpler version that can be entered in one cell, then filled or copied to the rest.
Sorry for this, but I think I may have found a "solution", but please advise.
The so-called "solution" is a bit tedious, in that, I would have to qualify all the types, names, etc.
Please see attached, and kindly advise how I can simplify this formula in the MA tab. Thank you!
Here is a simpler version that can be entered in one cell, then filled or copied to the rest.
- Works like a charm!! Thanks Hans!