Results 1 to 3 of 3

Index / Match / Lookup / VLookup / ??? Need Help

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2004
    Posts
    11

    Index / Match / Lookup / VLookup / ??? Need Help

    I am trying to lookup pairs of months in a table, then depending on what month pairs a user types in it will return the value from the table under the month pair in the table.

    See Attached Picture.
    The blue arrows represent where I want the values to go.

    For example,
    The user enters "feb" in A7 and "may" in A8. I want th then look through all the month pairs in the table above (B2:E3). It then recoginizes that B2&B3 Match, so it inputs 1.23 in cell B8.

    Your help is greatly appreciated.
    Attached Images Attached Images

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