Hello From Steved

=VLOOKUP($A71,Auckland!$A$1:$C$3009,2,FALSE)

In Auckland Sheet Ive got 101
In the Sheet I've got 101

If I overtype 101 in both sheets the formula works, is their please aformula
that will reconize whether it is a text or a number and the formula will work.

Thankyou.