Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
INDEX with 2 criteria search . . .
Hi Budget Programmer and Vonner,
My forte is not VB . . . so I’m sure there are more savvy ways o doing this but here’s a sample of my formula I created for a doubl criteria search, based on your example (Budget Programmer) =INDEX(DATA_FEED!$F$2:$F$10,MATCH(CONCATENATE(QUER Y!$A2,QUERY!B$1),DATA_FEED!$E$2:$E$10,0)) Attached is an of my formula using your example for your review hopefully this will get you closer to what your looking for. /// Caution this formula when copied over & over in a sheet, wil consume recalculating time /// that’s why I’m in looking into VB or SQ options (faster). But in the meantime server me well. FYI this will onl works for unique records / criteria. Otherwise it will return the 1s value it encounters and discard the others thus skewing your results. Fable Remember help others when ever your can Attachment filename: index (2 criteria search).xls Download attachment: http://www.excelforum.com/attachment.php?postid=69788 -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I search a whole workbook using the =INDEX function? | Excel Worksheet Functions | |||
search for Index+average in threads | Excel Worksheet Functions | |||
How to use an index number in a search range | Excel Worksheet Functions | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Using Search with either vlookup or match and index | Excel Worksheet Functions |