Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=T() function
I exported a file into an Excel spreadsheet. One of the columns has a =T( )
function which is preventing me from using the cells of this column for Vlookup. For example, one of the cells is =T("39601") and the value is evaluated to 39601. When I try to look this value up in a Vlookup, it returns #N/A error. When I manually replace it bt 39601, Vlookup starts working. How can I remove the =T from all the cells? What is this =T function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date & Time | New Users to Excel | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |