Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default VLOOK UP

I have used VLOOKUP but in few cells it is giving me #N/A in result. I have
noticed that if i change value in a cell from e.g. 111533 to '111533 it
solves the problem but i have more than 800 cells to change.
Is there an easy way to change the format?
Thanks
 
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
VLOOK-pivot table expanding want to update vlook automatically CrimsonPlague29 Excel Worksheet Functions 0 August 8th 07 09:44 PM
VLOOK-pivot table expanding want to update vlook automatically CrimsonPlague29 Excel Worksheet Functions 0 August 8th 07 09:44 PM
Need Help about vlook vlook fomula Excel Worksheet Functions 1 January 20th 07 02:42 PM
vlook up arcticale Excel Discussion (Misc queries) 1 January 25th 06 09:36 PM
#N/A with Vlook up Guy Wates Excel Discussion (Misc queries) 1 October 14th 05 02:02 PM


All times are GMT +1. The time now is 06:03 AM.

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

About Us

"It's about Microsoft Excel"