How about,
=IF('Another sheet'!A1="word",'Another sheet'!B1,"")

HTH
Kostis Vezerides

On Jan 26, 6:44 pm, dcjetx wrote:
I am creating a summary page for multi worksheets. Is ther a way to have a
cell mirror a row of info on the summary if a specific word appears in a
specific cell on the orginal worksheet?