formula help

[Emoncada]

what formula can i use to look for a word within 10 rows, and if the word is found to give me "Check Order".

example

In L13 have the formula

IF(F4:F13="Total","Check Order","Looks Good") and Ideas

 

[Peter_SSs]

Try something like this
=IF(ISNUMBER(MATCH("Total",F4:F13,0)),"Check Order","Looks Good")

 

[Andrew Poulsom]

Try:

=IF(ISNUMBER(MATCH("Total",F4:F13,FALSE)),"Check Order","Looks Good")

 

[speric07]

This is what you need to do use the formula and just copy down 10 rows.

=IF(A1=10,"Check order", "Looks Good")

Hope this helps

 

[Emoncada]

looks good thanks