hmm I tried to use your formula and there may be something wrong somewhere, I really need to get back into this, however looking at the sheep again, I have this a little backwards.
The number I need deisplaying is in column A,
So if there's a number 1 in column F, say F13, I need this cell to display A13....

I understand the simple =if formula but how would I get it to, index? the column and return a cell on the same row?
Cheers again all