Get instant live expert help with INDEX Function in Excel

I am trying to use a vlookup or index match but cant figure out how to do it whilst matching two variables.

How do I stop this N/A error on an Index Match Formula?

I am creating a league table using the following formula but if 2 names have the same amount of sales it is duplicating the first name on the list. =INDEX($E$2:$J$2,MATCH(1,INDEX(($E$34:$J$34=LARGE($E$34:$J$34,ROWS(P$13:P15)))*(COUNTIF(P$13:P15,$A$2:$J$2)=0),),0))

Trying to use Index and Match, to lookup two cloumns and return a date, but keep getting a "#Value" error

need help with a vba macro that i have Sub CF_Applied() 'create key index Range("K2:N5") sr = 2 sc = 11 Key = "" For r = 0 To 3 For c = 0 To 3 x = Cells(sr + r, sc + c).Interior.ColorIndex If x = -4142 Then x = 0 Else x = 1 Key = Key & x Next c Next r 'the above defines the range for the Key (Mask) to match sc = 5 For l = 2 To Cells(Rows.Count, "E").End(xlUp).Row Step 7 key1 = "" For r = 0 To 3 For c = 0 To 3 target = Cells(l + r, sc + c) Z = WorksheetFunction.CountIf(Range(Cells(l, sc), Cells(l + 4, sc + 4)), target) If Z = 1 Then x = 0 Else x = 1 key1 = key1 & x Next c Next r If key1 = Key Then Cells(l, sc - 1) = "Match" Else Cells(l, sc - 1) = "" Next l End Sub

Worksheets Involved: Column A of worksheet 'Key Issue Details' contains a list of exam titles Column C of worksheet 'Key Issue Details' contains a list of corresponding exam types (Audit, Credit Review, etc.) Cells A20:A22 of worksheet 'PickList' contain all of the possible exam types found in column C of 'Key Issue Details' Column C of worksheet 'Calendar & Exam Summary' (cells A5:A16), contains an empty list for all Audit type exams I want to enter a formula into cells A5:A16 on worksheet 'Calendar & Exam Summary' that will copy over all exam titles from 'Key Issue Details' column A, but only if 'Key Issue Details' column C matches any of the cells A20:A22 in 'PickList'. I am using the formula below which does retrieve this information, however instead of copying them over one after the other in Column C ('Calendar & Exam Summary'), it is matching row for row. For example: Formula being used: =IFERROR(INDEX('Key Issue Details'!$A$2:$B$2,MATCH(PickList!$A$20,'Key Issue Details'!$C$2:$D$2,0)),"") 'Calendar & Exam Summary' ...........'Key Issue Details' C5 - ...................................C2 - Exam A (doesn't match PickList) C6 - Exam 1.......................C3 - Exam 1 (Meets Criteria) C7 - ...................................C4 - Exam B (doesn't match PickList) C8 - Exam 2.......................C5 - Exam 2 (Meets Criteria) C9 - Exam 3........................C6 - Exam 3 (Meets Criteria) I would like it to look like this: Calendar & Exam Summary ........ Key Issue Details C5 - Exam 1........................C2 - Exam A (doesn't match PickList) C6 - Exam 2........................C3 - Exam 1 (Meets Criteria) C7 - Exam 3........................C4 - Exam B (doesn't match PickList) C8 - .....................................C5 - Exam 2 (Meets Criteria) C9 - .....................................C6 - Exam 3 (Meets Criteria)

If you are not the person who wrote this 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)) then dont think you can fix it. route it to him who wrote it.

Hello, I am using Excel 2016 to create a workbook that contains an 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

I need to know if a formula can be written to pull information from one tab into another based off multiple criteria. vlookup will not work but maybe an index and match formula can, I cannot get it to work and can upload the files

I have an index match match formula that isnt working for part of the data. Would you be able to assist with this?