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.
That could be like
or you may use ranges instead of entire columns