Return Value Based on Two Conditions

**JillC** · 02-12-2015, 05:39 PM

Excel Help 2-12.png

I'm trying to get Excel to return a value to one cell based on it two conditions are met. I've highlighted everything to match in the picture attached, but I will try to explain in as much detail as I can what I'm looking for. I would like to be able to put a formula in to C4 that I can copy down. I would like to have Excel check the information contained within J4 through M13 for two conditions. If the Facility Code in Column A and Column J Match and the Account Code in Cell C1 and Column K match, then it should return the account balance in Column M.

I’ve tried VLoopUp as well as Index and Match formulas without much luck (although admittedly, I may have entered some information incorrectly or used them improperly as I’m still a bit green when it comes to those formulas :P). Is this something even possible in Excel? I have to sort through about 1500 lines of data total out each different account, so I was hoping there was a formula to make it easier.

Any help would be greatly appreciated. Thank you!

**Brendan_Floyde** · 02-12-2015, 05:59 PM

Take a look at the Sumifs function

**MarvinP** · 02-12-2015, 06:01 PM

Hi Jill,

Find the attached with the needed formula. This is one of those Ctrl+Shift+Enter formulas where you can't just press enter when you are done with the formula. You need to hold down the Ctrl+Shift keys and then press Enter. They call these types of formulas CSE or Array formulas.

Here is my example workbook showing how they work.

Also look at this site for more help on this question:
http://spreadsheets.about.com/od/loo...s-tutorial.htm