Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Match / Index off two "keys"
I need a way to find a value (could be text) in column C based on the values in column A and column B. Entries in A and entires in B are not unique by themselves; however, by "keying" off columns A and B together, only one entry in column C results. Example: A-----B-----C D-----X-----Test1 D-----Y-----Test2 F-----Y-----Test3 I've tried various index and match combinations, but haven't figured it out yet. Any ideas? Thanks, JC -- carlyman ------------------------------------------------------------------------ carlyman's Profile: http://www.excelforum.com/member.php...o&userid=22440 View this thread: http://www.excelforum.com/showthread...hreadid=466313 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index and Match issues | Excel Worksheet Functions | |||
Match, Index, Vlookup, Large....Help Please | Excel Worksheet Functions | |||
Match & Index | Excel Worksheet Functions | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |