Multiple IF Statement

  • Thread starter Thread starter Bulletpoo
  • Start date Start date
B

Bulletpoo

Hello,

Im trying to make a cell produce a number only if another cell contain
any PERSONS name from another table.

EG

If B1=Joe Bloggs (or any other name from a list of about 30) the
B3=0.1

Is this at all possible? I hear VLOOKUP could be used here?

Cheers in advanc
 
With your list of names in E1:E30:

=IF(COUNTIF(E1:E30,B1),0.1,"")

HTH
Jason
Atlanta, GA
 
Back
Top