Results 1 to 7 of 7

Index/Match f(x) which Skips Blanks in Arrays

Threaded View

fbinaghi Index/Match f(x) which Skips... 10-16-2019, 12:57 PM
Pete_UK Re: Index/Match f(x) which... 10-16-2019, 01:28 PM
Pete_UK Re: Index/Match f(x) which... 10-16-2019, 01:30 PM
fbinaghi Re: Index/Match f(x) which... 10-16-2019, 02:07 PM
Pete_UK Re: Index/Match f(x) which... 10-16-2019, 02:09 PM
  1. 10-16-2019, 12:57 PM #1
    fbinaghi is offline
    Registered User
    Join Date
    10-16-2019
    Location
    California
    MS-Off Ver
    Latest
    Posts
    15

    Index/Match f(x) which Skips Blanks in Arrays

    Hello Everyone:

    I would greatly appreciate some help. I would like to insert an INDEX/MATCH function in cell B2:B2 in sheet one by pulling data from sheet 2. I've searched this forum and several other fora but I can't find the correct way to formulate an INDEX/MATCH function which skips blank rows. Below is data regarding to give context to my question. This is my first post! Best regards.

    Sheet 1

    A B
    Unit Tenant
    -250B
    -150
    -190D

    Sheet 2


    B C
    -250B CHERRY IMPROVEMENT ASSOCIATION
    [BLANK] [BLANK]
    [BLANK] [BLANK]
    -190D BERRY PALACE RESTAURANT
    [BLANK] [BLANK]
    -150 WANYE PLAZA DENTAL GROUP
    Last edited by fbinaghi; 10-16-2019 at 06:55 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index/Match two arrays
    By T86157 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-22-2017, 04:46 PM
  2. Index/match that skips null rows
    By kilohotel77 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2016, 11:08 AM
  3. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  4. [SOLVED] Formula for filtering that skips blanks?
    By jenlookxl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-11-2012, 05:08 PM
  5. Sum Index Match Arrays
    By CaesarBob in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2012, 04:38 AM
  6. [SOLVED] Index & Match returning incorrect value. Arrays fixed and exact match used.
    By SDes in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-07-2012, 08:29 PM
  7. [SOLVED] code skips blanks in data
    By Alan M in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2005, 08:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1