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 displayed when Lookup Formula is copied by Rachael F
Hello I have a lookup formula in D10 that looks up to range D75:D86 & displays the most recently entered (percent) value in the...
February 25th, 2008 12:48 PM
by Rachael F Go to last post
0 77
#N/A Error on VLOOKUP by roxiemayfield
I have this formula: =VLOOKUP(A20,EmpInfo,2) If A20 is Blank, I want the cell blank - instead I am getting #N/A What am I doing wrong?
December 8th, 2007 01:07 AM
by Pete_UK Go to last post
7 97
#N/A Error Reference by Sergio
I currently have a look up table and use the following formula: =VLOOKUP(C2&D2&E2,All_prices!$A$2:$H$33,8,FALSE) However, if any of the attributes in columns...
November 2nd, 2009 07:09 PM
by T. Valko Go to last post
2 149
#N/A Error unexplained by John C[_2_]
Okay, here is a question. I have a single spreadsheet that I am using for a mailmerge. However, I am getting an #N/A error that I cannot explain. I have...
August 21st, 2008 06:58 PM
by Duke Carey Go to last post
1 106
#N/A Error w/LOOKUP Function by sony654
The below function is producing exactly the result I want when I have a value entered in the LOOKUP range. But, if no values entered in the LOOKUP range t...
June 1st, 2008 05:22 PM
by T. Valko Go to last post
6 188
#N/A Error with VLOOKUP by Dan Marr
I'm having trouble with a "VLOOKUP" formula. I use Excel to open a text file where the text is separated by spaces. I go through the motions of establishing...
March 22nd, 2008 03:12 AM
by Jim Cone Go to last post
1 92
#N/A error with VLOOKUP function by Amer[_2_]
I am trying to get the highest value in one column and return the corresponding value of the same row using the following...
September 27th, 2009 11:22 AM
by Niek Otten Go to last post
3 148
#N/A error with VLOOKUP function by Leslie
I have the above problem, but only very intermittently, with a VLOOKUP table that ranks 32 percentages from highest (1) to lowest (32). It happened to...
April 22nd, 2004 06:38 AM
by Leslie Go to last post
4 470
#N/A error with Yield formula by Eddie
Hello all, I have a someone sharing excel 2007 spreadsheets with others using excel 2003. She is saving it in the 2003 format and everyone has the neccesary...
April 3rd, 2009 07:47 PM
by Ron Rosenfeld Go to last post
7 117
#N/A errors when matching time values by excelent
Hi fellows can sombody figure this out ? :-) http://pmexcelent.dk/Mappe11.xls Excel 2003 DK
July 28th, 2006 03:35 PM
by Jerry W. Lewis Go to last post
7 123
#N/A ErrorVLOOKUP HELP by Laya
I created a spreadsheet that will track Equipments and used a vlookup. I have the data in another tab in the workbook and created a name in the window for...
July 11th, 2007 09:50 PM
by Toppers Go to last post
1 131
#N/A help please by cadustin
I have tried to correct this formula with the ISNA, and not getting any result, please fix what I am doing wrong! I put the ISNA in the beginning and am...
April 15th, 2010 05:42 PM
by Duke Carey Go to last post
2 202
#N/A in a column I want to add by Cindy
I have a huge column of data that needs to be added. My problem is that I have quite a few #N/A in the column. Is there any way to get this column to add...
November 30th, 2006 07:52 PM
by Cindy Go to last post
0 69
#N/A in calculations by JonR
Hi I'm trying to work around some #N/A values in calculations. Columns A and B are populated with a conditional formula, and I'm trying to sum them in...
September 10th, 2006 07:33 PM
by Aladin Akyurek Go to last post
6 106
#N/A in lookup function by [email protected]
Hi I know this has been posted before but they only refer to VLOOKUP and not the LOOKUP function. I have created a function as...
November 23rd, 2007 02:33 PM
by [email protected] Go to last post
3 78
#N/A in mode worksheet function by broer konijn
Can anyone telle me when #N/A occurs as the answer to an worksheet function? If I try to find the mode of the list of codes below, I get...
June 15th, 2006 11:55 PM
by broer konijn Go to last post
3 79
#n/a in table data table output by dave
I constructed a one-variable data table and get several "#N/A"s returned in the body of the table, even though I don't get the "#N/A"s when I input the Input...
July 8th, 2008 03:40 PM
by dave Go to last post
2 115
#N/A in VLookup - Can I use another function that will return 0? by Arla
I am using a VLookup function. I need to find an exact match, but when there is no match, I would like to see a zero, rather than #N/A. Can someone help me...
January 30th, 2009 08:11 PM
by Gills Go to last post
9 147
#N/A is not text, cannot use it in functions by R-P
In short: Two tables, one with serialnumbers from 0 through 100 The other with ONLY selected numbers from this range from 0-100. I added the info from the...
November 22nd, 2005 05:07 PM
by R-P Go to last post
3 118
#N/A is showing up throughout worksheet by roy.okinawa
For some reason the error #N/A is showing up throughout my worksheet. What is most confusing about this is the formula(s) being used in different cells is...
March 24th, 2008 02:07 AM
by roy.okinawa Go to last post
3 105
Post New Thread


Display Options
Showing threads 161 to 180 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 02:22 PM.


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