VLookUp with Multiple Look Up Values - Array Formula Help

[atlasshrugged]

I am looking to do some form of Vlookup in an array form. I need to do the lookup on multiple values and return letters as opposed to numbers. For example:</SPAN>

Deal Numbers - Date - Rating</SPAN>
250 – 12/31/12 - AAA</SPAN>
255 – 12/31/12 - B</SPAN>
260 – 12/31/12 - AAA</SPAN>
275 – 12/31/12 - BBB</SPAN>
280 – 12/31/12 - CCC</SPAN>
285 – 12/31/12 - BB</SPAN>
290 – 12/31/12 – A</SPAN>
250 – 10/31/12 - AA</SPAN>
255 – 10/30/12 - BB</SPAN>
260 – 10/30/12 - AAA</SPAN>
275 – 10/30/12 - BB</SPAN>
280 – 10/30/12 - D</SPAN>
285 – 10/30/12 - CCC</SPAN>
290 – 10/30/12 - AA</SPAN>
250 – 9/31/12 - CC</SPAN>
255 – 9/31/12 - C</SPAN>
260 – 9/31/12 - AA</SPAN>
275 – 9/31/12 - BBB</SPAN>
280 – 9/31/12 - CCC</SPAN>
285 – 9/31/12 - BB</SPAN>
290 – 9/31/12 - A</SPAN>

I in the above example, I would want a formula to pull the rating for deal number 275 on 10/30/12 which would be BB.</SPAN>

As mentioned, I would like it to be in array form. I appreciate the assistance. Atlas</SPAN>

 

[Akashwani]

Hi,

Based on your sample data is this what you mean?...

Excel Workbook
	A	B	C	D	E	F	G	H
1	Deal Numbers	Date	Rating		Deal Numbers	Date	Rating
2	250	12/31/12	AAA		275	10/30/12	BB
3	255	12/31/12	B		255	9/31/12	C
4	260	12/31/12	AAA
5	275	12/31/12	BBB
6	280	12/31/12	CCC
7	285	12/31/12	BB
8	290	12/31/12	A
9	250	10/31/12	AA
10	255	10/30/12	BB
11	260	10/30/12	AAA
12	275	10/30/12	BB
13	280	10/30/12	D
14	285	10/30/12	CCC
15	290	10/30/12	AA
16	250	9/31/12	CC
17	255	9/31/12	C
18	260	9/31/12	AA
19	275	9/31/12	BBB
20	280	9/31/12	CCC
21	285	9/31/12	BB
22	290	9/31/12	A
23
Sheet9

The formula was taken from here.....

http://www.mrexcel.com/forum/excel-questions/306615-vlookup-multiple-criteria.html

I hope that helps.

Ak