Multiple column look up
 

I am needing to look up the BU and populate the type and also populate the GL
based on the AC.
BU AC GL Type
1 1010 1010 Operating
2 1010 1010 Operating
3 1010 1010 Operating
4 1010 1010 Operating
5 1010 1010 Operating
6 1010 1010 Operating
7 1010 1010 Operating
8 1010 1010 Operating
9 1010 1010 Operating
10 1210 1210 Non-Operating
11 1210 1210 Non-Operating
12 1210 1210 Non-Operating
13 1210 1210 Non-Operating
14 1210 1210 Non-Operating
15 1210 1210 Non-Operating
16 1210 1210 Non-Operating
17 1210 1210 Non-Operating
18 1210 1210 Non-Operating
19 1210 1210 Non-Operating
20 1210 1210 Non-Operating
21 1210 1210 Non-Operating
22 1210 1210 Non-Operating
23 1210 1210 Non-Operating
24 1210 1210 Non-Operating

Multiple column look up
 

Since your sample data shows only unique BU's, then normal VLOOKUP formulas
will return the AC, GL, and Type for any BU. However, if your real data
has multiple BU's with differing AC's then you can use a helper column to the
left of your data and concatenate the BU numbers with the AC numbers and
separated by a underscore...ie, 1_1010, and then do a VLOOKUP on this
combination column.

Vaya con Dios,
Chuck, CABGx3



"Multiple Column look up" wrote:

I am needing to look up the BU and populate the type and also populate the GL
based on the AC.
BU AC GL Type
1 1010 1010 Operating
2 1010 1010 Operating
3 1010 1010 Operating
4 1010 1010 Operating
5 1010 1010 Operating
6 1010 1010 Operating
7 1010 1010 Operating
8 1010 1010 Operating
9 1010 1010 Operating
10 1210 1210 Non-Operating
11 1210 1210 Non-Operating
12 1210 1210 Non-Operating
13 1210 1210 Non-Operating
14 1210 1210 Non-Operating
15 1210 1210 Non-Operating
16 1210 1210 Non-Operating
17 1210 1210 Non-Operating
18 1210 1210 Non-Operating
19 1210 1210 Non-Operating
20 1210 1210 Non-Operating
21 1210 1210 Non-Operating
22 1210 1210 Non-Operating
23 1210 1210 Non-Operating
24 1210 1210 Non-Operating

Multiple column look up
 

Have a look at the following link...

http://www.xl-central.com/lookup-mulitple-criteria.html

Hope this helps!

In article ,
Multiple Column look up <Multiple Column look
wrote:

I am needing to look up the BU and populate the type and also populate the GL
based on the AC.
BU AC GL Type
1 1010 1010 Operating
2 1010 1010 Operating
3 1010 1010 Operating
4 1010 1010 Operating
5 1010 1010 Operating
6 1010 1010 Operating
7 1010 1010 Operating
8 1010 1010 Operating
9 1010 1010 Operating
10 1210 1210 Non-Operating
11 1210 1210 Non-Operating
12 1210 1210 Non-Operating
13 1210 1210 Non-Operating
14 1210 1210 Non-Operating
15 1210 1210 Non-Operating
16 1210 1210 Non-Operating
17 1210 1210 Non-Operating
18 1210 1210 Non-Operating
19 1210 1210 Non-Operating
20 1210 1210 Non-Operating
21 1210 1210 Non-Operating
22 1210 1210 Non-Operating
23 1210 1210 Non-Operating
24 1210 1210 Non-Operating