how do i get a formula to look along a line

[tonylpcs@yahoo.co.uk]

Hi Everyone,

need a formula that can look at aline and indentify where the number is

i have a 20 line squire chart

along the top are first names and going down are second names, i need a formula that can look along the line (say line 10 cells D10 to D30) and find the cell that matches number 1 the take the name from the cell above it and put it with the name in cell C10 so i end up with one name!

any ideas?

thanks

Tony

 

[tonylpcs@yahoo.co.uk]

hi peter,

well im not sure what i was after out of the two options, but your suggestion worked perfectly so im happy!

thanks again

Tony