A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
#N/A problem by Jeff
Hi, The formula below works well. However, sometimes the result is a "#N/A" due to incorrectly entering the data (a typo). It is a lookup formula and causes...
July 6th, 2005 03:09 AM
by Jeff Go to last post
4 120
#N/A result because data is on another worksheet by Steve
I have this formula which refers to the Master Tab. =VLOOKUP($B4,MasterTab!$H$21:$O$923,8,FALSE) It usually works great, however, when the data is not found...
January 22nd, 2010 07:56 PM
by T. Valko Go to last post
8 127
#n/a result for vlookup by adimar
In the data below I attempt to find items in column C and return date in column B using =VLOOKUP(C2, A9:C11, 2, FALSE) A ...
March 28th, 2008 09:58 PM
by adimar Go to last post
5 96
#N/A resutls in Vlookup when there is a match by egamalaki
I need help in vlookp. Excel returns #N/A when actually there should be matching of information. Meaning the information am looking is present in the other...
May 30th, 2005 03:40 PM
by Ragdyer Go to last post
4 116
#N/A value is returned by Sai
I am looking for a number in a column and the result I want is either 0 or 1. if number is there i want 1 and if not 0. I am trying with vlookup function and...
July 15th, 2007 11:05 PM
by Dave Thomas Go to last post
7 106
#N/A via Vlookup to produce name from other worksheet by Steve
I have names in worksheets E & T. Mosdt names are in bith sheets, though some that are in E are not in T. I have this formula in the H column of worksheet...
October 19th, 2009 08:10 PM
by Steve Go to last post
2 148
#N/A! to be blank please. by Steved
Hello from Steved if no value it is returning a #N/A! please how to I have the cell blank I know it is iserror but not to shore how to go about putingit in...
August 22nd, 2005 10:02 AM
by Steved Go to last post
1 84
#NA by Alex H
I am creating a spreadsheet spreading forward for the next 12 months. Some ofmy cells have #NA in them as there is no raw data for the vloopup...
July 3rd, 2005 10:44 PM
by Alex H Go to last post
3 94
#NA as zero value by Janus Lee
Hi.. Help needed urgently In Sheet 1, i used VLOOKUP to find a specific GL code for value in Sheet 2. Due to that GL code in Sheet 1 that i have specified was...
July 3rd, 2005 03:43 AM
by CLR Go to last post
2 112
#NA Question by MCorrea
Hi, How do I configure a cell to instead of showing #NA to be blank or show 0. This would be just a mask thus the #NA that is appearing in the cell at this...
June 8th, 2004 08:41 PM
by MCorrea Go to last post
5 125
#NAME error by GerryK
Hi, I've been using the same spreadsheet for over two years and today get a #NAME error in my cells that contain NETWORKDAYS. When I check off Analysis...
November 16th, 2006 10:49 PM
by Dave F Go to last post
1 69
#name error by Excel Experimenter
c10 = 40; d10 can be any number above or below 40. The formula I am using is supposed to either read the number above or below 40 and read either # over or #...
July 7th, 2007 10:52 PM
by Wigi Go to last post
3 88
#NAME Error message by MJ
I have a client using Excel 95 and when he open my workbook - Excel 2007 he gets the error message #NAME, can anyone help with this problem. Campatibility...
August 18th, 2009 02:59 PM
by Luke M Go to last post
1 132
#NAME error with Workday function by JPS[_3_]
I'm using Excel 2003, the analysis toolpack is installed, and I calculated the workbook, but the error persists. It is only happening on one computer. Any...
March 13th, 2009 11:34 PM
by Chip Pearson Go to last post
3 119
#NAME when I open up my spreadsheet by Muttley
When I open up my spreadsheet I get a #NAME error in one of my cells, but if I go to the formula and press enter it gives the answer! Any ideas why it does...
October 21st, 2005 01:20 PM
by Muttley Go to last post
2 115
#NAME? by VoxBox-Richard
I'm getting the "#NAME" error in most cells when opening a spreadsheet is Excel 2003. I had the problem in 2000 but it was solved by using the analysis...
(Multi-page thread 1 2)
February 10th, 2009 03:17 PM
by VoxBox-Richard Go to last post
10 125
#NAME? by Connie Martin
I received a spreadsheet via e-mail and when I opened it all was fine. Formulas appearing to working perfectly. As soon as I saved it to my computer a...
December 31st, 2008 07:04 AM
by Shane Devenshire[_3_] Go to last post
7 93
#NAME? by 77Debbie77
I am pulling my hair out!!! I have over 60,000 rows of data with comments and am trying to add a function to a cell: =SUMPRODUCT(--('Closed calls as of...
August 28th, 2008 06:54 PM
by 77Debbie77 Go to last post
5 132
#NAME? by Harlan Grove
"Comcast News Reader" wrote... The function below returns the #NAME? error, and I'm not sure why. Any help on this will be...
December 27th, 2003 05:14 AM
by Comcast News Reader Go to last post
2 102
#NAME? Error by mp
I have a spreadsheet that I sent to a collegeau who is having difficulty with one of the formulas. The formula is returning the #NAME? error in the cell. ...
August 25th, 2009 04:05 PM
by T. Valko Go to last post
3 160
Post New Thread


Display Options
Showing threads 181 to 200 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:50 AM.


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