Prev: Publish interactive data to the Web using Excel (Problem)
Next: Link an entire Row with a Key Word
From: Sarah on 23 Mar 2010 09:31
Does anyone know if you can combine and IF, AND, and VLOOKUP. I need to
lookup 2 different dates in a table and if both of those dates appear on the
one sheet, I need the associated value to be returned. If this is possible,
how would I do this?

From: Bob Phillips on 23 Mar 2010 10:35
Use this array formula

=INDEX(rng3,MATCH(1,(rng1=condition1)*(rng2=condition2),0))

--

HTH

Bob

"Sarah" <Sarah(a)discussions.microsoft.com> wrote in message
news:BE6836D8-41BD-4DAD-A645-FF5BE0DAF0DD(a)microsoft.com...
> Does anyone know if you can combine and IF, AND, and VLOOKUP. I need to
> lookup 2 different dates in a table and if both of those dates appear on
> the
> one sheet, I need the associated value to be returned. If this is
> possible,
> how would I do this?
>


 | 
Pages: 1
Prev: Publish interactive data to the Web using Excel (Problem)
Next: Link an entire Row with a Key Word