Hi,
So I am looking for help with a formula for a complicated index match.
It will need to consider three things.
1) match items in each table
2) but only if values in a second column are the same +/- side of 0
3) and provide a result that does not match that provided in the first table.
I am ok with formula for multiple criteria, and I am ok with formula for does not match, and I am roughly ok with 'sign' formulas, however I have not been able to combine the these formulas.
Please see attachments,
Thanks
Bookmarks