RIGHT OR VALUE Function? I don't know which to use and how (2 tabs, 1 worksheet)

[rayted]

https://docs.google.com/spreadsheets...it?usp=sharing

Hi guys,

On my sheet above..

On my 2nd tab (admin snapshot), in cell C2, I want to take the number from the WC & DS breakdown tab, where it says: Default scores remaining: 1 or 2 or 3 (etc) so in the case of C2, I want to use RIGHT function to get the number from Cell A6

Can anyone please help? I don't know if I need use the RIGHT or VALUE function..??

[Pete_UK]

You can use this formula in C2 of the Admin sheet:

=RIGHT(INDEX('WC & DS breakdown'!A:A,ROWS($1:1)*5+1),2)*1

then copy down as required. It will result in a number, to which you can apply further calculations, and as it is copied down it will get the data from A6, A11, A16, and so on.

Hope this helps.

Pete

[rayted]

awesome, cheers Pete!