Get instant live expert help with INDEX Function in Excel

I want to dynamic access a sheet/cell from a closed file using INDEX. But when I try to "&A3&" for sheet name I forces me to select a file and then populates the sheet name instead of making it dynamically INDEX('/Users/me/Desktop/["&A2&"]"&A3&"'!A:A,1,1)

I need a formula that will pull items from a certain column, depending on two other criteria related to two other columns, and print out every instance that matches all of the above once and only once, and stop printing when all instances are printed. Currently have been relying on this for half of the job (printing one, and only one, instance of every unique element), but have not been able to incorporate the other two criteria: =ArrayFormula(index(RawData!$E$2:$E$500000, match(0, COUNTIFS($C$1:$C12,RawData!$E$2:$E$5000),0)))

Trying to get the sheet name in the formula below to change based on the text in a specific cell. So in the example below, if the text in cell A1 is currently "Sheet 1" and i change it to "New Sheet Name", the formula below would read that and replace 'Sheet 1'! with 'New Sheet Name'! =IFERROR(INDEX('Sheet 1'!$G$8:$G$2000, MATCH(0,COUNTIF(O$2:O3, 'Sheet 1'!$G$8:$G$2000), 0)),"")

I need help with a formula that uses index and match along with small, row and if statements to return multiple rows and columns of data from a matrix

I have two lists. One is a list of part numbers. The other is a list of long text descriptions. I can use VLOOKUP with "*"&cell address"*" to find the first match. But how can I find the second and third matches? I have tried using INDEX and SHORT but the vlookup wildcard no longer find the match like they do in VLOOKUP. Can you help?

I have a formula which I am trying to append, I would like to add d2:d301 to it. I've inherited the formula so not sure how to add to it current formula is =iferror(if(row()<>2,INDEX(arrayformula(filter($P$2:$P301,$C$2:$C301<>"",row($C$2:$C301)=max(if($C$2:$C301=C302,row($C$2:$C301),0)))) ,1),0),0)

I need a formula that will compare multiple columns, and return the column header name of whichever column had the highest value. I am using (INDEX($F$1:$K$1,0,MATCH(MAX(F2:K2),F2:K2,0))) , but one row had all the same values and the formula returned the first column header as being the "winner". This formula cannot distinguish when there are ties.

I'm trying to put the search and output lists for the following formula on a separate sheet. But simply selecting the data on that sheet won't work. =IFERROR(INDEX(E$2:E$6, AGGREGATE(15, 6, ROW($1:$6)*SIGN(MATCH("*"&D$2:D$6&"*", $A2, 0)), 1)),"")

I need a match index formula that will return the next unique value from a data set with criteria applying to multiple values. Right now the formula in row one returns a value, and the formula in row 2 returns the same value, instead of skipping that value and moving on to the next available one that meets the criteria. Currently I have this as my formula: J18:J34 = data I want returned K18:K34 = criteria corresponding to each J value G18:G34 = match lookup values F18:F34 = output =IF(INDEX($J$18:$J$34,MATCH(G18,$K$18:$K$34,0))=$F$17:F17,INDEX($J$18:$J$34,MATCH(G18,$J$18:$J$34))<>$F$17:F17,INDEX($J$18:$J$34,MATCH(G18,$K$18:$K$34,0)))

I have a file with two sheets. On the 1st, I have dollars in O13and in O16 a number signifying 1-6 people. On the second workbook is a matrix that corresponds to the dollar amount AND the number of people. For example, sheet 1 O13 is $6,000. O16 is 3. I want a formula to find $6,000 (not higher) on sheet 2 in column A. Then I want it to compare sheet 1 O16 to the correct column (B-G representing 1-6) on sheet 2 for an exact match to place in sheet1 O17. The range of sheet1 O13 is referenced on sheet2 A5-A383, and sheet 1 O16 is referenced on sheet2 B5:G383. I have an INDEX Match but it isn't quite working, yet.