I think you want to use =vlookup().

Visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
for nice instructions.

After you review her instructions, your formula may look like:

=if(vlookup()<=0,"included",vlookup())

(Less than or equal 0 should be included????)

Bob wrote:

I'm trying to build a proposal template that will pull prices from the
product spreadsheet (sheet 1). The formula I need is when the price for a
component is less than zero it would use the word "Included" in the proposal
template. The prices are in sheet 1. The proposal template would be located
in sheet 2.

--

Dave Peterson