Results 1 to 12 of 12

Help required with INDEX and multiple MATCH function - Excel 2007

Threaded View

  1. #1
    Registered User
    Join Date
    01-03-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    3

    Help required with INDEX and multiple MATCH function - Excel 2007

    Hi

    I've attached an example spreadsheet for what I'm looking to achieve. I'm attempting to create a formula that will look up the block, row and seat data found on the database tab and match these 3 cells data with the block, row and seat data on the area tabs. If the 3 cells data matches the 3 cells on the data tab, I would like the client name from the database tab to display in the client column in the data tabs.

    I think I should be using the INDEX and MATCH functions, but I'm having real problems making them work after brief success early on, I cannot get the cells displaying anything other than errors. Can anyone help?

    Thanks
    Ben
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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