isna function

  1. A

    Nested if with isNA formula help

    Hi all, I have a nested if statement and I am trying to add in if there is a #N/A to put a zero, but I am having trouble getting the formula to work. Any help please :) =IF($Y7="RevPro",SUMIFS('Q4-18 DRR'!$DX$4:$DX$50000,'Q4-18 DRR'!$K$4:$K$50000,$A7,'Q4-18...
  2. C

    VLOOKUP w/ multiple Column_Index_Numbers

    I have two files. File 1.) A sheet that I am trying to fill in. Using a PO umber from this sheet to search others sheets. File 2.) A year long Calendar. Each Week has its own row. This file has a range from A7 - AB1767. What I am trying to do is use a PO Number from File 1. Look for it in...
  3. T

    Use ISNA and MATCH functions to return a Yes or No when a match exists or not.

    Hey guys, I have been trying to figure out why my Excel formula is not working, but can't seem to figure it out. The web has a lot of information regarding ISNA, but when I use it the formula seems to be broken or something. I have the following formula in D4 of Sheet1: =IF(ISNA(MATCH(D3...
    • Tyron
    • Thread
    • if function isna function match function yes/no response
    • Replies: 6
    • Forum: Excel Questions
  4. F

    vlookup

    Hi, how to change vlookup that instead for found value, put just "yes" ? Dim rng, stullpath As String rng = ws2.Range("A4:" & Range("B4").End(xlDown).Address).Address sfullpath = "[" & ws2.Parent.Name & "]" & ws2.Name ws1.Range("A1").Select x_rows_vlookup =...
    • Forestq
    • Thread
    • if sstatement isna function vlookup vlookup #na vlookup #value!
    • Replies: 2
    • Forum: Excel Questions
  5. P

    Checking for #N/A value in nested IF statement

    Hello! I'm using a nested IF statement and calculating values based on the data in adjacent cells. I basically want part of my formula to do this check: If this cell isn't equal to #N/A, then display a certain value. Right now, my formula looks like this...
    • PNY80
    • Thread
    • isna isna function nested if nested if function
    • Replies: 1
    • Forum: Excel Questions
  6. A

    using if and isna function

    I want to create a function which returns a certain value if one of 3 conditions are met, and #N/A if it is false, So far my function looks like this, but isnt working properly. If A40 is zero, NA or blank, i want it to return BL12, and if it has a value, then NA...

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
Back
Top