I have a workbook containing 2 tabs.

Tab 1 has columnar data with column A containing locations; however, each location may be listed multiple times on different lines - once for each piece of equipment at that location. Tab 1, column B has a piece of equipment listed. Tab 1, column C has a price associated with the piece of equipment in column B.

Tab 2 contains contains columnar data with column A containing locations. I need to populate Tab 2, column B with the sum of all equipment associated with the location in column A.

I have used VLOOKUP to try and find matches for the lookup_value in Tab 2, column A, then return the value of the price from Tab 1, column C.

Problems have been that it returns only the first instance of the location data, not a sum of all. I know the formula is missing something, but cannot ID it.

Formula as used:

=VLOOKUP(B4,'Tab 1'!$I$4:$AI$461,3)

B4 is the column on Tab B that contains all of the locations (lookup_table)
Tab 1 I4 thru AI461 is the table_array where all locations are listed
3 is the col_index_num indicating that the price is in the 3rd column over

If this is not enough data to ealuate, please advise.

I'm stuck and in need of immediate assistance to meet a deadline. Any assitance is much appreciated, thanks!