isna

  1. S

    IF(ISNA(VLOOKUP to match 1 column with another

    So I moved the data that I want to use into 1 sheet and I want to compare data on Column 1 with Column B. I want to find out if the data on Column 1 also exist in Column 2. I am using "1" for exist, and "0" for not existing. The problem is, first I tried using my office notebook, but all the...
  2. G

    ISNA or VLOOKUP (DATE) or VLOOKUP (NUMBER)

    Hello, I am doing a vlookup on one column's values which includes multiple data types (dates, number, or #N/A for not available. The one column's results will either be: 1) a date (formatted MM/DD/YYYY) 2) or it will be a number, positive or negative 3) or it will be not available (#N/A)...
  3. C

    ISNA VLOOKUP INDIRECT combination does not work

    Hi all, I'm having trouble with the following formula below: =IF(ISNA(VLOOKUP($C$3,INDIRECT("'"&"*"&$B4&"*"&"'!$A:$A"),1,0)),"NO","YES")) The indirect function does not seem to work with the vlookup or I am doing it wrong. Please see below for the excel file...
  4. A

    IF, ISNA, VLOOKUP - Nested

    I have this formula below which works only on a single IF, ISNA & VLOOKUP statement: =IF(ISNA(VLOOKUP(G770670,Aircrafts!$A$2:$A$1000,1,FALSE)),"Others","CL650") However, when I expanded it to use multiple ISNA & VLOOKUP, it doesn't work...
  5. T

    VBA Range Function "N/a" error 2042...

    Hi guys, First time posting to a thread like this so apologies if I ask this query in a convoluted manner. That said, I am currently writing a macro for appending the range of an active worksheet to a .txt file for further analysis. Whilst I have successfully written this for a test excel...
  6. K

    I want to match the (Sheet1)clent /group to the (LookupTable)name /group and return the corresponding retention

    I want to match the (Sheet1) clent /group to the (LookupTable)name /group and return the corresponding retention. Formula i am using in Sheet1 cell-Retention Policy but is returning the wrong retention because I have multiple instances of the client/ name...
  7. N

    IFERROR Help (if column b in spreadsheet 1 matches column b in spreadsheet 2, return column E from spreadsheet 2)

    Here's my formula: =IFERROR(IF(ISNA(VLOOKUP(B2,'[Master Body Site.xlsx]Sheet1'!$B:$E,'[Master Body Site.xlsx]Sheet1'!$B:$B,FALSE)),"",VLOOKUP(C2,'[Master Body Site.xlsx]Sheet1'!$C:$C,'[Master Body Site.xlsx]Sheet1'!$C:$C+'[Master Body Site.xlsx]Sheet1'!$E:$E,FALSE)),"") I am trying to look up...
  8. E

    Using a formula with multiple sheets

    I have a spreadsheet with 10 sheets which will be used for keeping track of jersey number inventory. On the first page I have a table with rows ranging from XS to XL and each cell next to each range has a number representing a jersey number. On the other sheets, which are for each team, I have...
  9. A

    ISNA formula help

    Hi all - so I know how to use the ISNA formula with a Vlookup...BUT...I've tried and tried and can't figure out how to use it if you are using nested IF and VLookup. Here is my current formula...
  10. L

    If(ISNA(VLOOKUP Help... VBA

    Any advice as to why the below formula isn't working? My goal is supposed to return a "1" if the vlookup identifier is not found (ISNA) & add a 1 to the cell IF the identifier is found (IF, +1). Any advice? I've pasted what I am working on below =IF(ISNA(VLOOKUP(C[-2],'[PBDunkAcc.xlsx]Merrill...
  11. E

    Using IF, VLOOKUP, and ISNA to find Commonalities

    I have 3 sheets of data. Using IF, VLOOKUP, ISNA/MATCH, I have to create a formula in sheet 3 to find out if the value(A2), exists in either sheet 1, or sheet 2 or both. If the value is in sheet 1 exclusvely I need the formula to generate 1, if the value is in sheet 2 exclusively I need the...
  12. A

    Formula Exceeds Character Limit

    I have a formula that is too long for an excel 2010 cell. I will post it below, but the basic premise is that I have a spreadsheet that has 26 columns and > 8000 rows of data, many of which are n/a errors by design. For each row I want my formula to return the sum of the first 6 columns that...
  13. R

    Formula Problem: Not this address but the other, and blank if no address

    I'm putting together a workbook where I can load one sheet (raw data) and then in another sheet (product) extract the information I need for a specific format. The thought process is if the 1st address contains "Box", as in PO Box, then pull back the 2nd address. The criteria I'm using to look...
  14. S

    Hyperlinking with Formula

    Good Afternoon, currently I am using isna and vlookup to generate a report worksheet from a list on different worksheet in the same workbook. essentially, i'm using the "reporting checklist" sheet to input the information, and the "status report" worksheet to neatly present the information...
  15. T

    Hello Mr Excel world, help needed with IF, AND & ISNA combo

    Hi fellow Excel lovers, I need help to fix this seemingly simple formula but so far it's eluding me; =IF(AND (ISNA(R2),ISNA(U2),ISNA(X2)),"Needs Subbing", "Subbed") I've tried it with =TRUE after each reference and at the end of them and rearranging the brackets structure. I have a feeling...
  16. The_Rock

    Add ISNA to IFERROR formula

    Hi Folks I would appreciate your help with the following. I am using IFERROR to look up two different tables. If it cannot find it in any table, it returns #N/A I want to turn that #N/A to "-" This is the formula: =IFERROR(VLOOKUP(F12,'Non WE Oppties to include'!B:C,2,FALSE),VLOOKUP(A12,'Non...
  17. 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...
  18. E

    Putting a formula in the sentence part of a IF,ISNA,VLOOKUP string

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  19. G

    Countifs with one of the columns containing #N/As

    On sheet "Data2" Column A has the name of the Underwriter that saw a case (with repeated values), and column J has the name of the Doctor that the case was referred to. Many cases don't get referred to doctors, so those rows have a #N/A instead of the Doctor's name. (the Doctors names are...
  20. E

    Isna match vlookup

    Im pretty new to excel / Ive been away for a long time. So please be kind with what is probably an obvious problem. Im using ISNA MATCH from one worksheet named "Bonnet" (as in under the bonnet - to keep important things away from others that will be using this spreadsheet) to return values to...

Watch MrExcel Video

This Week's Hot Topics

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
Top