isna

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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>...
  17. 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...
  18. 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...
  19. P

    IF and ISNA trouble

    Not sure what I'm doing wrong. Tried a couple of things but cannot get to work. Trying to remove "######" from cell when time is left blank. here is formula: =IF(ISNA(F6-TIME(1,0,0)),"test",(F6-TIME(1,0,0))) if there is no time entered in cell F6, I'd like it to say "test"
  20. S

    using cell value in a formula

    A2 contains a forumula that returns a value of 12345. of course when you select on A2 it shows the forumula that creates that value. in b2 I want to add a formula that looks at the final value of A2 (12345) looks for it on a list of values in column c if result is N/A (bc value is not on C) -...

Some videos you may like

This Week's Hot Topics

Top