Text or Number
 

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.

Text or Number
 

The lookup won't recognize these interchangably, but if you know the format
of the table in which you're looking for the value, you can change the format
of A71 w/in the lookup formula to match that of the table.
If you've got text and the table is numeric, use =vlookup(value($A71),...)
If you've got a number and the table has text, use =vlookup(trim($A71),...)

"Steved" wrote:

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.

Text or Number
 

Thankyou

"bpeltzer" wrote:

The lookup won't recognize these interchangably, but if you know the format
of the table in which you're looking for the value, you can change the format
of A71 w/in the lookup formula to match that of the table.
If you've got text and the table is numeric, use =vlookup(value($A71),...)
If you've got a number and the table has text, use =vlookup(trim($A71),...)

"Steved" wrote:

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.