Retrieve text from col C if text matches in Col A & B

[Jubinell]

Hi,

Let's say I have a master table with company name, person name's and business title. Now have a subtable with names of a few companies and names of a few people belonging to those companies. I'd like to query from the master table the appropriate business title of those people in those companies.

Could you tell me the easiest way to do this?
I've looked around and explored a little bit with If array formulas, pivot tables, and MS queries. The problem I have is that the thing I want to pull is text, not number, and also there is a chance of duplication! (person A in company B may have multiple business titles in master table). I'd like to some how pull the correct text while keeping tag of whether the pulled data is unique or not.

Any advice would be greatly appreciated!

Edit: Creating a pivot table then deselecting the unwanted companies and people is not feasible since the master table contains more than 10,000 entries.

 

[jim may]

With your data set up like so,,

Excel Workbook
	A	B	C	D	E	F	G	H
1	My Criteria Range					OutPut
2	Co Name	Personnel Name				Title
3	ABC Company	Jim May	<< Enter Both Cells Here !!			Owner, VP-Ops	<< OutPut Here !!
4
5	Co Name	Personnel Name	Title
6	ABC Company	Jim May	Owner, VP-Ops
7	XYZ Co	Joe Doe	Manager
8	Ford Corp	Tom Ford	President
Sheet1

Excel 2007

You could paste into a Standard Module this code:

And your output would show up in Cell F3 I'd put a Forms Command Button on the
form to run the macro AFTER you enter new data in Cells A3 and B3

Just a thought...

Sub GetTitle()
    ActiveSheet.Range("A5:C8").AdvancedFilter Action:=xlFilterCopy, _
        CriteriaRange:=Range("A2:B3"), CopyToRange:= _
        Range("F2"), Unique:=False
End Sub