reza_doang
Board Regular
- Joined
- May 31, 2010
- Messages
- 187
Dear All,
i want to use vlookup and have more than 1 result. like sample below, i want to lookup Singapore and have result Cathy and Tony. If i use usual vlooup, only Cathy but how to pull out tony?
thanks
i want to use vlookup and have more than 1 result. like sample below, i want to lookup Singapore and have result Cathy and Tony. If i use usual vlooup, only Cathy but how to pull out tony?
thanks
Excel Workbook | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Data | |||||
2 | City | Name | Status | Age | ||
3 | Florida | John | OK | 30 | ||
4 | Sdyney | Billy | OK | 32 | ||
5 | Singapore | Cathy | Not OK | 28 | ||
6 | Singapore | Tony | OK | 49 | ||
7 | Malaysia | David | Not OK | 20 | ||
8 | ||||||
9 | ||||||
10 | ||||||
11 | Singapore | Cathy | Tony | |||
Sheet3 |