is it possiable?

  • Thread starter Thread starter darkangelstorm
  • Start date Start date
D

darkangelstorm

Hi all..

Is it possiable to make forumula that looks up a defined value / word
then read the name of the person with that value / word..

E.g

A1: Name B2:Check C:Proceed (Headings)

If B2="Yes" i would like it to display the name say on C1... prett
much copying the name to another cell really..

Macro codes? VB codes? or excel functions? able to do this.

Thanx in advance

DA
 
DAS,

How about, in cell C1

=IF(B2="Yes",A1,"")

Though I suspect you could also mean

=IF(B1="Yes",A1,"")

or if you have a bunch of names in column A, and only one Yes in column B

=INDEX(A1:A10,MATCH("Yes",B1:B10))

for the first ten rows.....

HTH,
Bernie
MS Excel MVP
 
Back
Top