LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
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 02:42 PM
vLookup with multiple lookup value in table array [email protected] Excel Worksheet Functions 2 September 26th 06 04:12 PM
IF, VLOOKUP & LOOKUP TABLE ON OTHER SHEET Serge Excel Discussion (Misc queries) 15 May 25th 06 05:30 AM
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY Scott Lolmaugh Excel Worksheet Functions 3 March 9th 06 11:05 PM
Pivot table formats text data with 2 decimals Don S Excel Discussion (Misc queries) 3 October 6th 05 12:45 AM


All times are GMT +1. The time now is 01:35 PM.

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"