On Thu, 30 Mar 2006 14:54:01 -0800, christine
wrote:

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....


You didn't say what you wanted returned if C2 is not one. I've assumed
null.

=If(pricing!$c$2=1,Pricing!B15,"")

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________