Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Formula returning zero
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-03-2018, 02:30 AM
Debaser's Avatar
Debaser Debaser is offline Formula returning zero Windows 7 64bit Formula returning zero Office 2010 32bit
Competent Performer
  
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default
Since your return values are text, you can also use:

=IFERROR(HLOOKUP(A3,years!A$1:F$5,2,0)&"","")
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hard Returning Phil H Excel 2 05-15-2018 03:29 AM
Hyperlink formula returning 'invalid site address' MarkH Excel 0 12-26-2015 10:43 AM
Formula returning zero Returning a whole row kevskisa Excel 2 07-28-2015 03:19 AM
Formula returning zero COUNTIFS returning Value Error ubns Excel 1 04-16-2015 02:00 PM
Returning Next Record to the top bordercollie10 Mail Merge 0 02-26-2009 09:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:58 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft