Quote:
Originally Posted by KeriM
Do you know of any formulas that will work for this? I added this into my post, but basically I need to lookup two values and return two values (as well as subtract them). I was playing with index and match, but I'm not having too much luck.
|
So you need to show three values (first, second and the difference between) for each combination in columns B & C?
I have a horrid feeling I'm completely misunderstanding what you're trying to achieve here... perhaps an example workbook would be a good idea?