Get instant live expert help with INDEX Function in Excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I am trying to brainstorm on how to get a formula to look up a contract, if it is between a certain date range return the value for the % associated with it. I have 2 tabs that it would be using in a spreadsheet, then it would need to multiply the MPDQ on spreadsheet 1 x the %x a fixed amt 1.084 to give the desired result.
I am not sure if I need to say it is November 1 and put in the formula that if it falls between this date range vlookup contract and return this value, or would it be easier to match index and do the calculation?
Solved by I. U. in 25 mins
I need to copy values via index to transfer data from duplicate values within a column into a secondary sheet. The duplicate values need to be shown is a second column
Solved by V. A. in 20 mins
index and match in excel forrmula to read value from the input cell
Solved by M. H. in 19 mins
hi need to add index match or indirect in this file
Solved by A. E. in 22 mins
hi need modification on sheet , do help me optimise it I want indirect or index match to make cost sheets
Solved by D. B. in 17 mins
hi how r u doing ? need help on sheet to add index match and indirect function
Solved by D. B. in 14 mins
hello need some optimizations on sheets and add indirect and index match function
Solved by G. Q. in 12 mins
lookup using index match match, but with a couple of wrinkles
Solved by T. J. in 20 mins
i need help with index match match, with a few wrinkles.
i was online with an expert about 1.5 hours ago, but i had to end my session
Solved by A. Q. in 22 mins
The below formula has a defined path '[TOC Model.xlsm]Partlist'!. This makes it choose a specific worksheet in a specific file. I need a vba code that can replace the hardcoded path with a user defines file chooser. The worksheet tab name (Partlist) remains the same
Range("B2").Select
Selection.FormulaArray = _
"=IFERROR(INDEX('[TOC Model.xlsm]Partlist'!R2C2:R10000C2,SMALL(IF(RC[-1]='[TOC Model.xlsm]Partlist'!R2C1:R10000C1,ROW('[TOC Model.xlsm]Partlist'!R2C1:R10000C1)-1),ROWS(R2C:RC))),"""")"
Selection.AutoFill Destination:=Range("B2:B5037")
Range("B2:B5037").Select
Solved by A. E. in 14 mins