Try something like this:

=IF(ISNA(MATCH(LEFT(A1,2)*1,Sheet1!A$1:A$5,0)),"", "your_word")

Copy this down to suit. Assumes your have proper numbers in Sheet1,
rather than text values.

Hope this helps.

Pete

On May 12, 3:03*pm, Santi wrote:
Hi,

I’m trying to construct a smart worksheet so when I enter a number or any
value it will automatically give me a specific result if it meets the
requirements from a first worksheet. This is an example of what I’m trying to
accomplish, please if anyone can assist I will be very grateful.

Sheet 1 * * * * * * * *Sheet 2 * * * * * * * * *
* * *A * * * * * * * * * * *A * * * * * * * * * *A * * * * * * * * * * * * * * * * * * * * *

1 * 20 * * * * * * * * * * * * * * * * * *1 704080000112 * * * *1 * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
2 * 30 * * * * * * * * * * *2 * * * * * * * * * 2 * * * * * * * * * * * * * * * * * * *
3 * 7 * * * * * * * * * * * * * * * * * * *3 * * * * * * * * * *3 *IF(LEFT(A1,2)=Sheet1! *
A1:A5,"CHARD"," ") *

Basically I want to use a formula that when the first to digits of a number
is equal to any of the numbers in sheet 1 the result would be any word I want
(example”Chard”) if not then I want the cell to be blank.