Microsoft Office Forums - View Single Post - help with a look up or if formula

Thread: help with a look up or if formula

View Single Post

Old

12-30-2011, 08:44 AM

beb1227

beb1227 is offline

beb1227 uses Windows XP

Windows XP beb1227 uses Office 2007

beb1227 uses Office 2007

Office 2007

Novice

The original poster

Join Date: May 2011

Posts: 18

beb1227 is on a distinguished road

Default

help with a look up or if formula

I am trying to come up with a formula that will do the following.

*I want it to search through sheet 1 Columns E through O

**I want it to look for the text HOLD

any time that it finds the word HOLD, I want it to paste the entire Row that it is found in sheet 2

not sure if this is a look up formula....or an if

anyone able to help

Reply With Quote