Lookup function problems with True/False

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)
 
This will return the index of the linked box (C1 to C10) which is TRUE

=MATCH(TRUE,C1:C10,0)

HTH
 
Back
Top