Index formula

[filiplenox]

Hi guys,

I have an excel problem:

1) Source: Location and Log in Number
2) Search Criteria:Location
3)Solution:All log in numbers in a certain Location
4)V LOOK UP just finds the first answer in the list

ty

 

[AhoyNC]

Maybe something like this.
INDEX formula is an array formula and must be entered with CTRL-SHIFT-ENTER.

Excel Workbook
	A	B	C	D	E	F	G
1	Location	Log#		Search	Loc4	# items	3
2	Loc3	169		Log#'s	121
3	Loc4	121			58
4	Loc4	58			123
5	Loc6	89
6	Loc4	123
7	Loc8	58
8	Loc6	68
Sheet