| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching cells | Excel Discussion (Misc queries) | |||
| Extract multiple records matching criteria from list | Excel Worksheet Functions | |||
| Find Matching Records in Two Worksheets | Excel Discussion (Misc queries) | |||
| Find matching records in two worksheets | Excel Discussion (Misc queries) | |||
| worksheet change and cases | Excel Worksheet Functions | |||
Linear Mode
