using VLookup

[reza_doang]

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

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

 

[SteveO59L]

Can you include a column to the left of your data ?