Can anyone help me to figure out how to match two cell values from sheet 1 and sheet 2, and return the cell value of sheet 3 of the same cell location.
For example:
Sheet 1 (Bin)
A B C D
1 . . . .
2 . 1 7 1
3 . 1 1 7
Sheet 2 (Sequence)
A B C D
1 . . . .
2 . 1 2 3
3 . 6 5 4
Sheet 3 (Design)
A B C D
1 . . . .
2 . A B C
3 . A B C
Output:
Sequence Bin Design
1 1 A
2 7 B
3 1 C
4 7 C
5 1 B
6 1 A
For example:
Sheet 1 (Bin)
A B C D
1 . . . .
2 . 1 7 1
3 . 1 1 7
Sheet 2 (Sequence)
A B C D
1 . . . .
2 . 1 2 3
3 . 6 5 4
Sheet 3 (Design)
A B C D
1 . . . .
2 . A B C
3 . A B C
Output:
Sequence Bin Design
1 1 A
2 7 B
3 1 C
4 7 C
5 1 B
6 1 A
