Results 1 to 9 of 9

Ignore "-1" in formula

Threaded View

  1. #1
    Registered User
    Join Date
    07-18-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    84

    Ignore "-1" in formula

    Hello

    I have this formula

    =INDEX([TUE.xlsx]Who_Did_What!$D1:$D10000,MATCH(1,($F7 = [TUE.xlsx]Who_Did_What!$C$1:$C$10000)*([TUE.xlsx]Who_Did_What!$D$1:$D$10000<>""),0))

    Column D in "TUE.XLSX" has many '-1's in it so therefore the cell with this formula in it returns -1

    The cell with the formula is trying to return an employee ID of which im doing a VLOOKUP to match a name with. There is nobody with this ID '-1'.

    What can i put in this formula to ignore minus numbers or just specifically -1.

    It has to be in this formula as the users are not advanced users and will not know anything about formulas.

    I attached an example - cant attach the original for DP reasons

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Pivot Table / Chart Ignore / Exclude blank "" cells created using IF formula
    By randomreflex in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-23-2018, 08:59 AM
  2. If one cell =0, ignore other formula and show "0"
    By robbielaybourn in forum Excel General
    Replies: 2
    Last Post: 07-14-2017, 10:12 AM
  3. Data Validation - how to ignore cells with "0" or "-"
    By dgibney in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-29-2015, 08:16 PM
  4. [SOLVED] array formula count "number of" - can it ignore blanks
    By nigelog in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-24-2014, 09:33 AM
  5. [SOLVED] Counting data only contains text (ignore mark "-" & "")
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-12-2014, 09:45 PM
  6. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  7. VB Macro for Proper Case to Ignore "/" & "-"
    By jlcford in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2008, 07:49 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1