If Question

[mattajanke]

I know this is an easy question, but cannot remember how to do this.
--------------A-----------------------B------------------------C
1-----800 Lengends Run--------$61.25
2


In Cell C1 i need a formula for: if A1 is equal to "800 Legends Run" then return the value of B2.

Thanks in advance

 

[NBVC]

=If(A1="800 Legends Run",B1,"") assuming you really wanted B1 not B2

 

[MarkAndrews]

=IF(A1="800 lengends run",B1,"")