|
|
#1
05-18-2015, 06:50 AM
|
|||
|
|||
using two lookup values to get a sum figur
In the array below i need to use a formula in col D to Sum the total for DMC shown in Col A
is this at all possible, if so how. I need this for a another table which will have only one category unit i.e Airport, Client Costs J$J, Contingency, DMC, Guides and show results of column D Thank you  A B C D Airport Transfers 700 700 Client Costs J&J Events 4800 4800 Contingency Fees 1000 1000 DMC Dinners 500 2850 DMC Gratuities 50 DMC Handling Fees 250 DMC Lunches 50 DMC Salary 2000 Guides Single 200 200 
|
|
#2
05-18-2015, 11:55 AM
|
||||
|
||||
Please post a sample sheet. Thx
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#3
05-18-2015, 01:16 PM
|
|||
|
|||
|
As per your request
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Lookup / Paste Multi Values VBA
|
Mav | Excel Programming | 6 | 05-10-2015 08:42 PM |
| Lookup multiple values and compare different scenarios to get a specific result | mws | Excel | 5 | 05-24-2014 04:52 AM |
| How can match or lookup values from two separate tables? | klawk26 | Excel | 1 | 07-31-2012 09:04 PM |
|
Possible Lookup
|
Karen222 | Excel | 3 | 01-10-2012 05:41 AM |
|
LookUp
|
aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |
Windows 7 64bit 
Office 2013
Linear Mode
