Text or Number

[Guest]

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.

 

[Guest]

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),...)

 

[Guest]

Thankyou

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),...)