1. J

    IFERROR VLOOKUP - remove #n/a when blank

    I have this formula I'm using to lookup style numbers from a table on another sheet (called Items) and input the description. My original formula was "=IF(F3="","",VLOOKUP(F3,Items!A:D,2,FALSE))" This worked great in that it removed the #N/A message if the cell was left blank and it looked up...
  2. B

    How to show MAX in row that contain #N/A value

    Hi All, How to show MAX in row that contain #N/A value ? this is the formula =IF(C3=MAX($C$3:$C$9),C3," ") but the problem is if there are #N/A i can't show MAX. Any help is appreciated.
  3. M

    VLOOKUP = #N/A error

    Hi all, I've got a super simple VLOOKUP for a diet plan I'm working on with my partner. For the life of me though, I can't understand why the #N/A error is occurring. I'm using a Data Validation list that is directly linked to the source table so even if there were hidden spaces it...
  4. Bagharmin

    Error using CUBESET with date range

    I've been using this CUBESET function without issue for a couple of weeks to calculate a sum between two dates, but today it's giving me an #N/A error...
  5. M

    VBA Vlookup - if part number not found then display Msgbox and Exit Sub

    Hello, I have following macro which on Error will resume to next. Now I want to display a message box if an error is found and after exit SUB Message box( "Part number" & "PN" & "not found. Please define packaging details") By PN should be displayed the part number that is not found. Sub...
  6. T

    VLOOKUP shows #N/A

    I can't get why..
  7. J

    Vlookup error

    I have a vlookup in one spread to look up qty's in another and is erroring #N/A. when I go to the lookup table and click in the cell and hit F2 and enter the error goes away. so I then try to copy this down and I have to go cell by cell hitting F2 enter. not changing anything. is there some...
  8. D

    #N/A error with Lookup and Min functions

    Good Afternoon everyone, I have run into an issue using Lookup with Min. I can use Lookup with Max and get the required results, =LOOKUP(MAX(E7:E1000),E7:E1000,D7:D1000) actually gives the date that matches the Max value. When I change the formula to =LOOKUP(MIN(E7:E1000),E7:E1000,D7:D1000), it...
  9. R

    VLOOKUP and extract #N/A rows

    Hello experts! I hope my question is as easy for you as it seems to me: I've got two tables I'm comparing. Both tables have the index, StudentID, a 10-digit number. I'm using vlookup to compare the tables to find which students are missing from either table (Table A compared to Table B, and...
  10. R

    Disreguard #N/A when adding a column of numbers.

    I have a column of numbers that come from a vlookup. I want to add this column up skipping the cells with a #N/A result from the vlookup. Thanks guys.
  11. I

    Value VLOOKUP is searching for is negative - returns #N/A

    Team, Trying to keep this example simple. I have a pivot table: <tbody> A B C 1 Aisle # Locations Units 2 001 229 1569 3 002 1 -12 4 003 12 214 </tbody> I am trying to combine information in a spreadsheet from three pivot tables using the VLOOKUP. However, when I try to display the...
  12. M

    Return value if there is an #N/A error

    Okay so I have a list of numbers that will be pasted next to an already placed VLOOKUP function, this VLOOKUP will lookup the numbers pasted in another list. This means the VLOOKUP returns a list of all the numbers that already exist in the 'lookup list' and then #N/A if a new number is there. I...
  13. C

    #N/A Values

    <tbody> 1 1 #N/A 2 #N/A 3 2 4 3 #N/A 4 </tbody> I have a bunch of #N/A values in columns. what's the easiest way to get the desired result (1234) in the adjacent column with no empty cells in between?
  14. G

    Formula N/A Error

    Good Afternoon, I'm getting an error with my formula... but only sometimes not every time. =INDEX(DlyRateCodes1!$D$27:$K$455,MATCH($CD11,DlyRateCodes1!$B$27:$B$455,0),MATCH(H$1000,DlyRateCodes1!$D$26:$Z$26,0)) If you could give me an idea of what's wrong, that would be great. I know this is...
  15. H

    Transpose formula returning #N/A in certain cells where values in source data is blank

    I have the following transpose formula which is an array =-TRANSPOSE('C:\downloads\[BR1.xlsm]Summary'!$C$3:$L$3) Where the cells on sheet "summary" C:L are blank , then the formula returns #N/A I have tried using iferror, but get the same result It would be appreciated if someone could...
  16. pcorpz

    help tweaking my formula ifna match index

    {=IFNA(INDEX(PO[Price],MATCH([@[SO Date]]&[@[User Name]]&[@[Item No.]]&[@[SO Qty]],PO[Posting Date]&PO[User Name]&PO[Item No.]&PO[Quantity],0)),INDEX(PO[Price],MATCH([@[Item No.]]&[@[Cost Exact Match]],PO[Item No.]&PO[Sales Exact Match],0)))} My formula works but I know it should be written...
  17. M

    Sumif with index and match if two criteria are met

    Hi, Looking help in constructing a formula to help me interrogate a large data area which if 2 criteria or met then sum the associated hours worked. Basically I want a summary report that gives me the total hours worked by a particular grade for each month as we go through the year. Below is...
  18. A

    Why this Match is not working, FILE ATTACHED

    Hey guys, can someone tell me please why this file is not working? https://sheet.zoho.com/sheet/editor.do?doc=2f316a5f957451ed09ebbb4a127947ccf5a1467f845cffe4c8a8094a66592afeb433327fda0a94208330b6f8e188e67294c4ed9a2e62d8dd325f910d1a209e47 am using (...
  19. N

    Formula problem referencing cells with #N/A

    Hi, I’m trying to create a formula that involves using IF and OR. The problem is that the columns the formula references have a lot of #N/A errors in them, so the result of the formula ends up being #N/A if there is an #N/A in either column H or column I. It just seems to disregard what is in...
  20. V

    Vlookup - multiple columns

    Hi, Every month a sales report is pulled showing all activity for each sales person from the beginning of the year. This tab is the total sales overview. It is sorted alphabetical per sales person. Then a tab is created per sales person. Each of these sales person tabs needs to reflect all...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back