Results 1 to 3 of 3

MATCH with two columns: nested?

Threaded View

  1. #1
    Registered User
    Join Date
    11-18-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    2

    MATCH with two columns: nested?

    Hi All,

    I'm an excel noobie and in my opinion my first excel task seems pretty complicated. So here it goes.

    I have two columns of data. Timestamp and TagNames. Both have duplicate entries. There is a third column, Value.

    For each timestamp & tagname combination, there is a unique value.

    I want to be able to create a conditional search statement which takes Timestamp and TagName as input and gives me the Value that matches both conditions.

    I would immensely, greatly and all synonyms thereof appreciate your help!!!

    Thanks!
    Last edited by bagarwal; 11-18-2010 at 06:31 PM. Reason: Problem solved!

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