Results 1 to 7 of 7

Index Match lookup thru multiple columns

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-01-2010
    Location
    Niles, Michigan
    MS-Off Ver
    Excel 2010
    Posts
    137

    Index Match lookup thru multiple columns

    Is it possible to have excel perform a match lookup in 3 different columns?

    i have cell M14 that is doing an index Match function and is matching cell D14 and cell M8in sheet "7-4-10" thru column D and column B on another worksheet ("Weekly Total") in the same book.

    But can it perform this same match looking thru column B, L, and V in sheet "Weekly Total" to match cell D14 in worksheet "7-4-10" and look thru column D, N, and X in sheet "Weekly Total" for cell M8 in sheet "7-4-10".

    And if it finds the match then return the value from in column H, R, or AB in sheet "Weekly Total"?
    Last edited by Zimmerman; 07-09-2010 at 01:54 PM.

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