Vlookup --- Searchable Drop Down Lists

You probably need to use the index/small/if ARRAY. Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Hi

See the file!!

This what you looking for?

Regard

Is this what you had in mind?

Data Range

	A	B	C	D	E
1	Customer	City	------	City	Customer
2	A	Pittsburgh		Beaver Falls	C
3	B	Altoona			F
4	C	Beaver Falls
5	D	Mars
6	E	Pittsburgh
7	F	Beaver Falls
8	G	Altoona
9	H	Pittsburgh
10	I	Butler

This array formula** entered in E2:

=IFERROR(INDEX(A:A,SMALL(IF(B$2:B$10=D$2,ROW(B$2:B$10)),ROWS(E$2:E2))),"")

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down until you get blanks.