muhammad susanto
Well-known Member
- Joined
- Jan 8, 2013
- Messages
- 2,077
- Office Version
- 365
- 2021
- Platform
- Windows
hi all...
how to lookup different sheets:
in sheet data
my target in sheet lookup
thank for anyone help
susant
how to lookup different sheets:
testing.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | city | name | ||
2 | jakarta | a | ||
3 | jakarta | b | ||
4 | jakarta | c | ||
5 | jakarta | d | ||
6 | hongkong | g | ||
7 | hongkong | h | ||
8 | singapore | x | ||
9 | singapore | s | ||
10 | singapore | r | ||
11 | singapore | t | ||
12 | singapore | w | ||
13 | singapore | k | ||
data |
in sheet data
testing.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | name | city | ||
2 | a | #N/A | ||
3 | c | |||
lookup |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B2 | B2 | =VLOOKUP(A2,data!$A$2:$B$13,2,FALSE) |
my target in sheet lookup
thank for anyone help
susant