Excel Function Help

  • Thread starter Thread starter Corky
  • Start date Start date
C

Corky

I have two columns in my example. In one column all
entries are zero except for one which is a 1. In the
other column there are names. How do I identify the cell
with the 1 and return the corresponding name in the
adjacent column.

Thanks
 
Say your zero's and 1 are in column A and your names are in column B. Use
this formula:-

=INDEX(B1:B5,MATCH(1,A1:A5))
 
Corky, try

=INDIRECT("B"&MATCH(1,A1:A3000,0))
or
=VLOOKUP(1,A1:B3000,2,FALSE)

--
XL2002
Regards

William

(e-mail address removed)

| I have two columns in my example. In one column all
| entries are zero except for one which is a 1. In the
| other column there are names. How do I identify the cell
| with the 1 and return the corresponding name in the
| adjacent column.
|
| Thanks
 
Back
Top