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!

If by value you mean numeric, then you can use SUMIFS()

e.g.

=SUMIFS(C:C,A:A,"X",B:B,"Y")

this will look for an X in column A and a Y in column B in same row and give the value in the same row at column C...

If you have more than one matching record, then it will sum the corresponding values.

if the column to retrieve is text, it is a bit more complicated, but something like:

=INDEX($C$1:$C$100,MATCH(1,INDEX(($A$1:$A$100="X")*($B$1:$B$100="Y"),0),0)

you are recommended not to use whole column references with this one though, as it is more resource intensive.

Another way would be to add a column that concatenates A&B column and then perform a simple index/match

e.g. =INDEX(C:C,MATCH("X"&"Y",D:D,0)) where column D contains concatenated cells...

Note: you can replace "X" and "Y" with cell references too.