Forum Discussion
Inbedded Trim in a complex Index Match MMULT formula
I am working on setting up a reconciliation, and I need to lookup Placement numbers on the reconciliation. I am looking up against the invoice no., and this is index matched against four differen...
This makes it difficult to use VLOOKUP to find a value based on more than one criteria. However, if you have control over the source data, you an add a helper column that concatenates 2 more more fields together, then give VLOOKUP a lookup value that does the same.