excelexcel-formulaexcel-2013
How to achieve return of one value with multiple criteria
What I'm trying to achieve: Return one value by multiple criteria (from 2 cells). How: Intersection of particular row or column.
Based on picture, Row=Units Sold , Column=Years(2011,2012,2013,Total)
I tried using INDEX+MATCH because it sounded like what I'm looking for. But it doesn't allow multiple criteria, or at least I've tried and failed. I've also tried IF+VLOOKUP, failed again. All my effort would either return error N/A or #Value , etc.
Searched through this website but I can't seem to find what I'm looking for. I'm sure it's pretty simple, but I'm sort of a beginner at Excel. So, apologies if this question overlaps. And, HELP.
Solution
Try:
=INDEX(B2:F18,MATCH(H17,B2:B18,0),MATCH(I17,B2:F2,0))
- Excel number format to only show decimals when necessary
- Private Sub for hiding worksheets based on cell value "View" / "Hidden"
- Power Query Filtered Rows based on value
- EDI translator to excel
- If formula (the sum is less than 30 then roundup tp 30)
- Unable to use a dynamic named range as a data series - what am I doing wrong?
- How to get the path of current worksheet in VBA?
- vba + copy sheet from one wb to another wb
- Is it still not possible to open Excel from a Word Add-In?
- Excel-365 functions don't work as expected
- Sum values based on three criteria and transpose result from tabular to visual layout
- How to use fraction string in Excel/Calc/Sheets as formula
- VBA Code Save in Local and Upload to Sharepoint
- List Sheet Names Without Macro or Excel 4 Functions
- Delete a specific value from one column and Rename another Value in Excel using office script
- Highlight cell in first column if row contains a partial text match
- Excel - Aggregate dynamically values in a Table using array formulas (MAP, BYROW, CHOOSECOLS, TEXTJOIN, LAMBDA, FILTER, HSTACK) in a single Cell
- How to convert a FILETIME to an excel date
- VBA CountIf() loop / Countifs() loop
- How to construct Dataframe from a Excel (xls,xlsx) file in Scala Spark?
- excel filter data and remove units of measurement
- How to reference the current User\Desktop location in VBA
- Apache POI autoSizeColumn Resizes Incorrectly
- Copy cell values to another worksheet based on cell value
- Import Excel to Pandas Dataframe, but preserve order of Day/Month in dates?
- M Code(Power Query) to Remove Empty columns that runs fast
- Excel Count if first character is 0 in string
- How can I send Excel range including header, in table, and email to list?
- Dropdown Lists Emptying When Filling Data in Worksheet
- Excel: How to take a weighted average where blank values cause proportional weighting shifts