Results 1 to 13 of 13

IFERROR with VLookUP and 2 critera

Threaded View

  1. #1
    Registered User
    Join Date
    03-02-2018
    Location
    Nottm
    MS-Off Ver
    365
    Posts
    72

    IFERROR with VLookUP and 2 critera

    So I have a list of stores 1 - 13 that are in my range of A32:B55

    In my cell, I need to see if that store number is listed in 2 different columns.

    Here's my formula for one column only, but I want it to give me "both" if the store number is listed in 2 different columns (not just F19 in this case), and "missed" if only in 1 column or neither column. So I need to include the "If(AND somewhere, just not sure how to make that work.

    =IFERROR(VLOOKUP(F19,$A$32:$B$44,2,FALSE),"MISSED")

    Thank you.
    Last edited by KirbyKat; 04-17-2019 at 12:40 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vlookup in pivot table mulitle critera
    By mfputer in forum Excel General
    Replies: 1
    Last Post: 06-01-2016, 11:32 AM
  2. Replies: 1
    Last Post: 10-16-2014, 04:29 PM
  3. [SOLVED] Iferror vlookup
    By chris.slater in forum Excel General
    Replies: 2
    Last Post: 04-20-2012, 03:37 AM
  4. Excel 2007 : Vlookup with critera in multple columns
    By fentontech in forum Excel General
    Replies: 1
    Last Post: 11-17-2011, 12:42 PM
  5. IFERROR With VLOOKUP
    By Badvgood in forum Excel General
    Replies: 2
    Last Post: 05-11-2011, 09:27 AM
  6. Excel 2007 : Vlookup and iferror help soon...
    By MRKINGSTON1976 in forum Excel General
    Replies: 1
    Last Post: 10-28-2009, 03:21 PM
  7. Vlookup (3 critera)
    By Engineers08 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2008, 11:44 AM

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