Calculating a distance with if statments

[bboysen]

Hello once again!!!!

I have this formula that works but I need to expand it!

This is what i have:
=IF(K4="XR",IF(B4=INDEX(B$5:B14,MATCH(1E+100,IF(K$5:K14="XR,B$5:B14))),"",B4-INDEX(B5:B14,MATCH("XR",K5:K14,0))),"")

This will give me a distance from once xr to the next xr but now i need to get it to work from xr to either a xr, xw, xwtc.

I have tried or and using the +, but that will not work i just get #VALUE.

So in the B column i have a number lets say

B2= 100.00 & K2=XR
B3= 150.00 & K3=XW distance between the two is 50 in say column AD
B4= 160.00 & K4=XWTC distance between the two is 10 in say column AD

and so on.

If you need more info please let me know. I have hit a dead end and hope the master minds on here can help.

Thanks