Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > Vlookup is giving #N/A
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 3,872
Default Vlookup is giving #N/A
Hi,

Am Tue, 10 Nov 2015 08:12:11 -0800 (PST) schrieb
:

=VLOOKUP(B5,'Oct 15'!B:F,5,FALSE)

try:
=IFERROR(VLOOKUP(B5,'Oct 15'!B:F,5,0),0)
and format the cell as expected.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

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
Vlookup: giving me REF# problems. Help Dave Excel Discussion (Misc queries) 2 December 4th 08 07:30 PM
vlookup not giving correct output houghi Excel Discussion (Misc queries) 3 July 3rd 08 05:28 PM
vlookup not giving correct output Tom Hutchins Excel Discussion (Misc queries) 1 July 3rd 08 03:21 PM
Vlookup giving #N/A matt_the_brum Excel Worksheet Functions 12 August 4th 06 09:17 AM
VLookup in VBA giving error message ayl322 Excel Discussion (Misc queries) 3 July 27th 05 06:06 PM


All times are GMT +1. The time now is 02:02 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"

 

Contact Us ExcelBanter forum home Privacy Statement