Two lookup values for a vlookup?

[culpepper]

Hello,

I need to pull data based on financial quarter AND year (ex: Q1 of 2010). Is it possible to incorporate both into the lookup value of a vlookup? Is there some other way to do this?

Any help would be greatly appreciated.

Thanks

[Jacc]

http://exceltactics.com/vlookup-mult...g-index-match/

http://www.excel-university.com/vloo...teria-columns/

http://blogs.office.com/2012/04/26/u...okup-formulas/

[FDibbins]

I can think of a few ways of doing this.

1 relatively simple way would be to use a helper column to combine the 1 columns of info, then use that for the search. This column can be hidden if needed, and if you put to the left of your data, you could use VLOOKUP.

	A	B	C	D
1	Option 1, helper on the left
2	A1	B1	11
3	Helper	Data1	Data2	Value
4	A1B1	A1	B1	11
5	A2B2	A2	B2	22
6	A3B3	A3	B3	33
7	A4B4	A4	B4	44
8	A5B5	A5	B5	55
9	A6B6	A6	B6	66

C2=VLOOKUP(A2&B2,$A$4:$D$9,4,0)

If you add the helper to the right, then INDEX/MATCH is the tool to use.

	A	B	C	D
11	Option 2, Helper on the right
12	A1	B1	11
13	Data1	Data2	Value	Helper
14	A1	B1	11	A1B1
15	A2	B2	22	A2B2
16	A3	B3	33	A3B3
17	A4	B4	44	A4B4
18	A5	B5	55	A5B5
19	A6	B6	66	A6B6

C12=INDEX($C$14:$C$19,MATCH(A12&B12,$D$14:$D$19,0))

	A	B	C
21	Option 3, No helper, using ARRAY
22
23	A1	B1	11
24	Data1	Data2	Value
25	A1	B1	11
26	A2	B2	22
27	A3	B3	33
28	A4	B4	44
29	A5	B5	55
30	A6	B6	66

C23=INDEX($C$25:$C$30,MATCH(A23&B23,$A$25:$A$30&$B$25:$B$300))

There are a few more complex formulas you could use, but hopefull, 1 of these will give you what you need

Another, slightly more complex approach would be to use am ARRAY formula