Sum of Vlookup results

[dleesBLX]

Looking for help with Vlookup 

Trying to use a formula and I think VLookup or Lookup is the solution. 

Want to find the total revenue for the office ORD from the table below. Result should be ($1795 + $1295 + $1150 + 310) = $4550. 

VLookup gives me just the first solution - $1795. So I think i'll need to add them up some way. 

[#2]

@dleesBLX 

That could be like

=SUMIF($B:$B,"ORD",$F:$F)

or you may use ranges instead of entire columns