Excel Question:
Sheet 1
C1 C2
North 101
South 102
Sheet 2
(C1: random but with texts North and South. There are lets say 1000 rows)
C1 C2
North 101 (in this case)
South ?
South ?
South ?
North ?
....
Question: How do I get exact Number in Sheet 2, C2 (with the ? mark) that matches number from sheet 1, C2.
Thanks.
Bookmarks