finding first value in a column

  • Thread starter Thread starter korros
  • Start date Start date
K

korros

I'm trying to figure out how to do the following

worksheet = base

A14 = forumla???

worksheet = single_heal

A2= Fred
O2 = 0

A2 = barney
O3 = 1

A4 = dave
O4 = 1

what I would like is a formula that will put barney in A14..
It kinda works with
=CONCATENATE(IF(single_heal!O2=1,single_heal!A2,""),IF(single_heal!O3=1,single_heal!A3,""),IF(single_heal!O4=1,single_heal!A4,""))

But with the above A14 = barney dave

I only want the first 1 to show .. iee A14 = Barney

ideas???
 
Korros,

try

=CONCATENATE(IF(single_heal!O2=1,single_heal!A2,""),IF(single_heal!O3=1,single_heal!A3,""),IF(single_heal!O4=*0*
,single_heal!A4,""))
 
If yu copied column A to column P (and hide ?) you could use the formul
:-
=VLOOKUP(1,single_heal!$O$1:$P$20,2,FALSE
 
Kieran

the O column is a formula that yeilds a 1 or 0, I should have pointe
that part out. so I never know which row will be the one I want th
information out of the A column.

BrianB

I'll have to play with the VLOOKUP a little, I've never used i
before.


Thanks to both for your replies.

Korro
 
Back
Top