Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default VLOOKUP not working due different formats in lookup data & table?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9,101
Default VLOOKUP not working due different formats in lookup data & table?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 791
Default VLOOKUP not working due different formats in lookup data & table?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
LOOKUP is working - but VLOOKUP is not Jay Excel Discussion (Misc queries) 3 December 13th 06 03:42 PM
vLookup with multiple lookup value in table array [email protected] Excel Worksheet Functions 2 September 26th 06 05:12 PM
IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET Serge Excel Discussion (Misc queries) 15 May 25th 06 06:30 AM
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY Scott Lolmaugh Excel Worksheet Functions 3 March 10th 06 12:05 AM
Pivot table formats text data with 2 decimals Don S Excel Discussion (Misc queries) 3 October 6th 05 01:45 AM


All times are GMT +1. The time now is 04:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"