Looking for a combination formula with certain critera

Hi - paste this ARRAY FORMULA in D2 and copy down. You'll need to adjust the ranges:

=IFERROR(INDEX($B$2:$B$16,MATCH(1,($A$2:$A$16="New York")*($C$2:$C$16=$C2),0)),"")

Row\Col	A	B	C	D
1	location	description	company	output
2	New York	OK2	aaa	OK2
3	Detroit	OK3	bbb	OK11
4	Detroit	OK4	ccc	OK8
5	Detroit	OK5	ddd	OK13
6	Detroit	OK6	aaa	OK2
7	Detroit	OK7	bbb	OK11
8	New York	OK8	ccc	OK8
9	Detroit	OK9	ddd	OK13
10	Detroit	OK10	aaa	OK2
11	New York	OK11	bbb	OK11
12	Detroit	OK12	ccc	OK8
13	New York	OK13	ddd	OK13
14	Detroit	OK14	aaa	OK2
15	Detroit	OK15	bbb	OK11
16	Detroit	OK16	ccc	OK8

*You must press CTRL+SHIFT+ENTER to confirm entry of an ARRAY FORMULA in the Formula Bar.
When copying the formula to other cells, make sure the copied cell is not part of the Paste Area.

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee