I am not sure what it is that you want, but if it is to extract the number at the right of the string in Track Table!D2 you can use:



=LOOKUP(9^9,-RIGHT(D2;ROW($1:$100)))

Thanks Xor,

I'd like to incorporate that if I can. I was puttering around a little more with what I started and think I established a very basic version attached.

In the first worksheet labeled Track I would need to somehow make a dynamic range so that when I add new updated rows the table will expand and formulas in col F would follow suit to match corresponding cell values and data range. Hope this makes sense.

Attached Files

Prototype Model.xlsx (17.7 KB, 11 views)

I am still in doubt, but take a look at the attached (also see Name Manager) and let me know if I have misunderstood.

Attached Files

Prototype_2.xlsx (18.8 KB, 9 views)

Not sure what part you may find doubtful. Thanks for the suggestion. I found a working configuration. I can share if interested. Bet I''ll be back when I encounter new stuff to learn. Cheers!