Get instant live expert help with INDEX Function in Excel

I am trying to do business with the Florida Department of Health. In order to do this, I need to produce a text file that meets their specifications. I have an Excel spreadsheet that takes input from an HTML copy of the Google sheet. Formulas in the spreadsheet take that information and parse it out into two additional spreadsheets. I then take those spreadsheets and convert them to a text file. My problem is that the text file produced by the spreadsheet does not look like the text file required by the state of Florida. Their file specification looks like this: User ID, 501044-REFRIGERATOR 1 Index,Date,Time,Readings(F), Inspection Mark 1,"8/11/2015","4:59:04 PM",41.4, 2,"8/11/2015","5:14:04 PM",41.4, 3,"8/11/2015","5:29:04 PM",41.5,Person1 4,"8/11/2015","5:44:04 PM",41.5, My file looks like this: User ID,MPEDS-F,,, Index,Date,Time,Readings (F),Inspection Mark 1,1/26/2018,11:02:00 PM,-2, 2,1/27/2018,12:02:00 AM,-1.7, 3,1/27/2018,1:02:00 AM,-2.2, 4,1/27/2018,2:02:00 AM,-1.8

Hi, I would like to find a way to tell A:A to look in B:B and where it finds say COMMS as indexed in E:E for it to insert COMMS in A:A. Can this be done please? My index table excel will have approx 10 more categories and the project list will run into the 100s, Thanks and I attach a basic sample for reference.

I want help with a ms excel index match for multiple criteria. Basically I want to see all unsold ad names (col a) for selected car name ( row 1) in sheet3. "N" in col e/j/o etc denotes that an ad is unsold.

Continuation of my last question... INDEX(Sheet2!A:A,small(IF("N"=INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19),ROW(INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19))-ROW(INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Sheet1!B:B,MATCH(MATCH(Sheet3!A2,Sheet2!1:1,0)+3,Sheet1!A:A,0))&19),1,1)+1),1))

Hello, I am using Excel 2007 to create a workbook that contains an excel index sheet and then several reference sheets. I am attempting to create hyperlinks on the index sheet to jump to the reference sheets and then I want to convert the workbook into a pdf. My hyperlinks all work as expected within excel but seem to be disabled in the pdf document. I have searched the web and this seems to be a common issue with lots of ideas on how to resolve it but none have worked. Thoughts?

You have made this but now I want to insert new row in sheet two but it won't get added in overview sheet. The formula is =IFERROR(INDEX(Sheet2!A:A,SMALL(IF(INDIRECT("sheet2!"&INDEX(Formula!B:B,MATCH(MATCH(Overview!$A$2,Sheet2!$1:$1,0)+3,Formula!A:A,0))&3):INDIRECT("Sheet2!"&INDEX(Formula!B:B,MATCH(MATCH(Overview!$A$2,Sheet2!$1:$1,0)+3,Formula!A:A,0))&19)="Y",ROW(Sheet2!E3:E20)-ROW(INDEX(Sheet2!E3:E20,1,1))+1),ROW()-1)+2),"")

I need to incorporate data validation into the following formula: =IF(C2="Credit Contract Agreement Unsigned",INDEX($D$2:$D$934,MATCH(CONCATENATE(B2,"Credit Contract Agreement Signed"),$E$2:$E$934,0)),"") Column F has a date 14 days after the loaded date, and I need to ensure that whatever result date for a signed is pulled falls within those two dates.

In the sheet named 'Scenarios', I have top 10 values among the range C23:K31,C52:K60,C81:K89,C110:K118,C139:K147,C168:K176,C197:K205,C226:K234,C255:K263,C284:K292,C313:K321,C342:K350,C371:K379,C400:K408,C429:K437,C458:K466,C487:K495,C516:K524 in column M using the 'LARGE' function. I want the corresponding column B value of each of those top 10 values in column N. Someone gave me a formula for another file for a similar problem and I have used that here. I have used the IFNA,INDEX and MATCH function. The formula has worked fine till the Column G in cell N3. But it does not cover the columns H, I, J and K. When I try to extend the formula for those columns, it shows error. Please help me get the right formula so that it also looks up the columns H, I, J and K.

VLOOKUP function to display the number of calories in the selected boxed set. Use the boxed set listed in cell I5 as the lookup value, the range A14:D17 as the table array, column number 2 as the column index number, and FALSE as the range lookup value. Useabs in excel cell I5 and the range A14:D17.

Hi All. I hope you are ok and hope you can help.I am looking for a complex formula. I believe is a mix of Index, Match and V-look up. I have also attached a file. Basically the formula should lookup the value 22 of Cell I16 into cell C8, also it should look up the value 20 of cell H7 into cell B5 and the same for any other cellof the table on the left.