vlookup with multiple values

[dissertationhelp]

Hi,
Could someone write me a quick vlookup (or equivalent to sort a problem)?
I have a list of company index, announcements and dates, (index A announcements column B dates column C). Using vlookup only finds the first value but what i need is a formula that looks for the right company and date and returns the index which is in column A.
For example
A.............B..............C
2345...........BP..........1/1/2001
1658...........BP..........8/5/2006

What i have is
F...............G...................H
BP..........8/5/2006.......REQ INDEX

So what i want is a formula that will search for both the name and date in order to return the correct index into column H as using a vlookup only returns the top one.
Thanks

[PeteABC123]

Try this. Added a helper column. Change your range as applicable, and probably should have made them absolute references. Have at it. Please report back.

Vlookup to the left with multiple values.xlsx


Pete

[dissertationhelp]

Pete,
That is perfect!!
Thanks so much for your help and all the other help i've had on here!
I think you might have rescued my degree!
Thanks again

[FDibbins]

You could either use a helper with the vlookup, or use index/match. I will show you the INDEX/MATCH method, seeing as this is a little more complex...

	A	B	C
1	2345	BP	1/1/2001
2	1658	BP	5/8/2006
3
4
5	BP	8/5/2006	1658

C5=INDEX($A$1:$A$2,MATCH(A5&B5,INDEX(B1:B2&C1:C2,0)))