Lets say I am in column 6, row 10.
Column 4 data is one letter per cell, something like this: a,b,a,c,d,e,b,c,f,d
I want a formula that looks up the value of Column 4, row 10 ... gets d.
Then checks whether an earlier cell contains d ... in this case yes, in row 5.
Then goes to Column 2, row 10, and gets the value there ... say 15.
Then goes to Column 2, row 5, and gets the value there ... say 5.
Then does the calculation (15-5) and inserts the value 10 in column 6, row 10.
Is this possible in Excel ?
It would be great if it could be done.