Results 1 to 8 of 8

Combining Index & Match Functions

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2010
    Location
    Michigan, USA
    MS-Off Ver
    Excel 2003
    Posts
    22

    Question Combining Index & Match Functions

    I have used the forum before and really received wonderful help, so I am hoping for much needed help again.

    I have a set of raw data on sheet1, which I reference to sheet2 to populate a particular form. The raw data specifies attributes for apartment communities, including rents by unit type. Ultimately, I am trying to populate sheet2 with information about 5 communities. Populating sheet2 for the basic attributes works fine with my standard Index & Match function for each of the 5 communities, but when I get to the point of populating sheet2 for unit specifics, it won't seem to work. Specifically, the first community works fine, but I can't figure out how to populate the next 4, it just pulls data for the first community? The reason its a little tricky, at least for me, is because each community may have several versions of the same basic unit type (3 different 1-bed/1-bath models, etc.), plus I can't seem to figure out how to properly flag the data I want to select in terms of populating the size, bed, bath, and rent fields. I have attached the basic file and would greatly appreciate any insight, it is beyond my capacity to figure out. I have highlighted the cell on sheet2 that is the problem area. I assume that once I resolve the formula for that cell, the others will be no problem. Thanks again.
    Attached Files Attached Files
    Last edited by bmc1975; 10-28-2010 at 11:06 AM.

Thread Information

Users Browsing this Thread

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

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