I have a column of 10 rows linked to 10 check boxes which change the values
in the column between true and false. There will be only one value of True in
the whole column at any one time. The column to its right acts as the result
vector column. I cannot get the lookup function to display the result vector
when a box is checked making its linked box true. Can any body help me with
this?

Thanks

This will return the index of the linked box (C1 to C10) which is TRUE

=MATCH(TRUE,C1:C10,0)

HTH

"pelsue" wrote:

I have a column of 10 rows linked to 10 check boxes which change the values
in the column between true and false. There will be only one value of True in
the whole column at any one time. The column to its right acts as the result
vector column. I cannot get the lookup function to display the result vector
when a box is checked making its linked box true. Can any body help me with
this?

Thanks

I think you want something like

=INDEX(G1:G10,MATCH(TRUE,F1:F10,0))

or

=VLOOKUP(TRUE,F1:G10,2,FALSE)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pelsue" wrote in message
...
I have a column of 10 rows linked to 10 check boxes which change the values
in the column between true and false. There will be only one value of True
in
the whole column at any one time. The column to its right acts as the
result
vector column. I cannot get the lookup function to display the result
vector
when a box is checked making its linked box true. Can any body help me
with
this?

Thanks