Thank you to all three of you. You saved me a lot of work!

"Newbeetle" wrote:

This should do you,
In sheet 2 cell B18 type,

=IF(Sheet1!A22="single story system",Sheet3!B5,"")

If it doesn't say single story system in sheet 1 cell A22, B18 stays blank,
if it does it displays the value from sheet 3 cell B5


--
This post was created using recycled electrons!


"RPW" wrote:

I have a workbook with multiple sheets. On one sheet, for cell a22 (which is
a thru g 22, merged), a value is entered, say 'single story system'. I want
another cell (say b18), on another sheet, to pull a value from a third cell
(say b5) on the third sheet, if cell a22 on the first sheet has 'single story
system' as its value.

I hope I have explained this clearly.