| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Excell-How to add the number of cells containing text? = a sum | Excel Worksheet Functions | |||
| Change number in Text Box in Excel | Excel Discussion (Misc queries) | |||
| Format Number to Text | Excel Worksheet Functions | |||
| 16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
Linear Mode
