G
Guest
Dear Sir,
I need to fill up column C in List 1 by looking up references in column A
and column B at List 2.
Worksheet Illustration:
LIST 1 - Transportation Acitivity
A B C
1 FROM TO MOVE
2 KL JB 68
3 PG IP #NA
4 KL KB 10
5 KU BU 48
6 JB PG 30
7 JB SP 22
8
9
10
11 LIST 2
12 FROM TO MOVE
13 JB SP 22
14 JB PG 30
15 KL JB 68
16 SW KG 25
17 PK ML 36
18 KL KB 10
19 KU BU 48
20
21
22
May I know what formula must I input at cell C2 and copy down to get the
straight answer ?
Can VLOOKUP formula be used to search for data with two reference?
Thanks
Low
I need to fill up column C in List 1 by looking up references in column A
and column B at List 2.
Worksheet Illustration:
LIST 1 - Transportation Acitivity
A B C
1 FROM TO MOVE
2 KL JB 68
3 PG IP #NA
4 KL KB 10
5 KU BU 48
6 JB PG 30
7 JB SP 22
8
9
10
11 LIST 2
12 FROM TO MOVE
13 JB SP 22
14 JB PG 30
15 KL JB 68
16 SW KG 25
17 PK ML 36
18 KL KB 10
19 KU BU 48
20
21
22
May I know what formula must I input at cell C2 and copy down to get the
straight answer ?
Can VLOOKUP formula be used to search for data with two reference?
Thanks
Low