Hi christine,

How about ...

=IF(Pricing!$C$2=1,B15,"")

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM



"christine" wrote in message
...
here is what I need and all attempts of writing it have failed.

in cell d3 of worksheet C, I need:

value of b15 of worksheet A only if cell c2 has a value of 1
worksheet A is called pricing

one formula I tried:
=index(if(pricing!$c$2=1, b15... or something like that....