Lookup function problems with True/False

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

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

=MATCH(TRUE,C1:C10,0)

HTH