Matching 2 cases at once.
 

How do you use VLookup (or another command) to find an entry that is
dependant on two other entries at once? In other words, A is
independent, B is dependent on A, and C is dependent on A and B. My
brain hurts.


--
mae1778
------------------------------------------------------------------------
mae1778's Profile: http://www.excelforum.com/member.php...o&userid=25716
View this thread: http://www.excelforum.com/showthread...hreadid=399568

Hi Mae1778. In the "search for" dialog box type "lookup multiple items" , go
to post lookup/if statements and look at Dave Peterson's response. HTH
--
Sincerely, Michael Colvin


"mae1778" wrote:


How do you use VLookup (or another command) to find an entry that is
dependant on two other entries at once? In other words, A is
independent, B is dependent on A, and C is dependent on A and B. My
brain hurts.


--
mae1778
------------------------------------------------------------------------
mae1778's Profile: http://www.excelforum.com/member.php...o&userid=25716
View this thread: http://www.excelforum.com/showthread...hreadid=399568

Once you know what's in A2 and B2...

=index(othersheet!$c$1:$c$10,
match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet !$b$1:$b$100),0))

(just to save a few moments searching <bg)

mae1778 wrote:

How do you use VLookup (or another command) to find an entry that is
dependant on two other entries at once? In other words, A is
independent, B is dependent on A, and C is dependent on A and B. My
brain hurts.

--
mae1778
------------------------------------------------------------------------
mae1778's Profile: http://www.excelforum.com/member.php...o&userid=25716
View this thread: http://www.excelforum.com/showthread...hreadid=399568

--

Dave Peterson