Search code examples
Returning a value with multiple column criteria in Excel...


excelexcel-formulacelllookupindex-match

Read More
Search for Value in a table...


excel-formulaxlookupindex-match

Read More
Speeding Up Index-Match for Large Dataset...


excelvbaoptimizationindex-match

Read More
Matching multiple number rows and check corresponding dates within 90 days...


exceldateif-statementexcel-formulaindex-match

Read More
Find Corresponding Value Based on Today's Date Falling Between Week-Ending Dates in Excel...


exceldateexcel-formuladate-rangeindex-match

Read More
Sheets: My function uses commas to separate the INDEX MATCH results, but I don't want a comma fo...


google-sheetsindex-match

Read More
Xlookup multiple match types...


excelexcel-formulaxlookupindex-match

Read More
Dynamic index match using indirect function to pull from other sheets...


excelexcel-formulaindex-match

Read More
Create Gantt Chart style timeline from data in three columns...


excelvbatimelineindex-match

Read More
Google Sheets - Index, Match, & Importrange - What is wrong with my formula?...


google-sheetsgoogle-sheets-formulaindex-match

Read More
INDEX MATCH to also pull through notes...


excelvbauser-defined-functionslookupindex-match

Read More
Excel Sumproduct with multiple criteria lookup in two tables...


excelmultiple-conditionssumproductindex-match

Read More
R: Replicating an INDEX MATCH to the Corresponding Column...


rapplylookupindex-match

Read More
I have a dataset of team members reserving one ( or more) of five rooms. I need a function that can ...


google-sheetsarray-formulasindex-match

Read More
I want to automatically populate a calendar sheet with scheduled meetings as team members select dat...


google-sheetsarray-formulasindex-match

Read More
how copy specific cells from one worksheet to another, on varying rows with spaces. Somehow use inde...


excelvbaspreadsheetindex-match

Read More
Unable to fetch data from first table into another based on more than 1 parameter...


excelexcel-formulaindex-match

Read More
How to match any one of several possible values in a range, and filter matches by another value...


excelexcel-formulaxlookupindex-match

Read More
Approximate match of date and exatc match of string in Excel...


excelexcel-formulavlookupindex-match

Read More
Based on a value in one cell, how do i find its nearest value in a series of numbers in another cell...


google-sheetsgoogle-sheets-formulaspreadsheetlookupindex-match

Read More
Both XLOOKUP and INDEX-MATCH aren't returning requested value...


excelexcel-formulaxlookupindex-match

Read More
Problems with Index Match Array returning duplicates...


excelexcel-2016index-match

Read More
Google Sheets Array Formula issue...


if-statementgoogle-sheetsnestedarray-formulasindex-match

Read More
How to return the first non-error value (#N/A) in index match?...


google-sheetsformulaindex-match

Read More
Sum Value from other workbook with criteria...


google-sheetsgoogle-sheets-formulaindex-match

Read More
Trying to return values from a table based on 4 criteria - not exact matches...


google-sheets-formulaindex-match

Read More
SUMIF rows based on selection on other table...


excelsumifsindex-match

Read More
2-factor lookup with an approximate match in Excel (not 365 version)?...


excelexcel-formulalookupindex-match

Read More
google sheet punch card...


google-sheetsindex-match

Read More
Dropdown List Populating Information...


google-sheetsdrop-down-menuvlookupindex-match

Read More
BackNext