What does the 1/(LEFT(A1:A7,4) do to the text?

"T. Valko" wrote:

Maybe this:

=LOOKUP(2,1/(LEFT(A1:A7,4)="1006"),A1:A7)

Also if I search for numbers beginning with 1008
I need to know that there is none present.

The above formula will return #N/A.


--
Biff
Microsoft Excel MVP


"OX_Gambit" wrote in message
...
Hello,

I have the following list of number and need to find the last number that
starts with 1006? How do I do that? Also if I search for numbers
beginning
with 1008 I need to know that there is none present.

1005001
1005002
1006001
1006002
1006003
1007001
1007002