got a formula that works fine just dont understand bits of it formula




=IF(INDEX(Sheet1!$CD:$CD,COLUMN(B31))="ok","Y","N" )

I understand which column and sheets it refers to the only bit that i dont get is the B31 as it dose not matter if i change it to B333 it still refers to to the cell that is second down in column CD ie. cell CD2 it dose not affect the workbook but i was just interested in the way the formula works

COLUMN(B31) results in 2 as B is the second column in the sheet . I have no idea why B31 is used instead of 2.
INDEX(Sheet1!$CD:$CD,COLUMN(B31) thus returns the second value it finds in column CD and proceeds with the IF condition

So in fact it says : IF the second value in column CD is "ok" then "y" otherwise "n".
It seems a bit far-fetched on it's own, but maybe put into context it is logical

Cheers

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

its to enter results in a form from a tester which outputs in a csv file which shows ok and i need it be to Y or N on the form so as i understand it the column becomes abcd going down instead of 1234