Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I think it is a formatting problem but not certain on this. How do I make
the lookup data and the column in the table array the same format so the lookup works? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The format wont stop lookup from working. Usually the problem is either the
cell is text and the formula is looking for a number or the reverse is happening. Look for double quotes " in either the formula or the cell. Second possiblity is there is spaces in the formula or the cell. To check for spaces in the cell you can use =len(A6). Make sure there isn't any spaces. "MikeNeilWalker" wrote: I think it is a formatting problem but not certain on this. How do I make the lookup data and the column in the table array the same format so the lookup works? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If the cell number is text (which is usually the case) and you are using
Excel 2003, when you select the cell with a "text" number you will see a little warning box to the left if you click on it one of the options is convert to number, do that and the lookup should work. If you are using an older version of excel you can convert the cell using the =value( ) function "MikeNeilWalker" wrote: I think it is a formatting problem but not certain on this. How do I make the lookup data and the column in the table array the same format so the lookup works? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
LOOKUP is working - but VLOOKUP is not | Excel Discussion (Misc queries) | |||
vLookup with multiple lookup value in table array | Excel Worksheet Functions | |||
IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET | Excel Discussion (Misc queries) | |||
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
Pivot table formats text data with 2 decimals | Excel Discussion (Misc queries) |