Hi,

This is awesome thank you! I've been trying with the VLOOKUP function with little success.

I'm having a look at the attachment you sent. For the first cell it seems to work well. When I try to fill series, the cells in the "Sheet2!$D$2:$D$12" part of the function change as well.

Is there anyway of keeping these constant as I fill series? Because I'm effectively trying to match all my data to a single fixed table. At the minute the programme seems to think that my UICC table is moving down a cell as I use the fill series function... I'm a total dummy though so I may have missed a trick!

As for the Tx and N1a - those are just little nuances in the staging, I've altered those in my worksheet to bring them in line with the rest of the data and it doesn't cause any problems with the UICC outcome. I've also extended the UICC index to include the possible TNM combinations that can be found in my full dataset.

Attached Files

Second attempt.xlsx (14.7 KB, 9 views)