small if

Dear All, We are using Office 365 and have created an excel file where using GET DATA FROM SQL SERVER Database we are importing a view from a database: The table has the following headers and data according the data of the specific Car and the month ABCDEFG3iddatecardriverSHIFTclient receive...

Hi Guys Having a problem with the Index matching function on excel. I'm using a SMALL IF function to pull the smallest 10 figures from one sheet to another and then using index matching to take these figures and pull a particular code associated to that figure from the sheet (The code and the...

Cells D4:I8 as listed. <tbody> X X Text1 Text2 Text3 Text4 Text5 Lowest 1.12 2.23 2.21 1.22 3.21 1.22 1.29 2.12 1.89 0.00 2.01 2.01 1.17 0.00 2.17 2.88 2.90 1.34 </tbody> Cells D4:H4 are a named range of EX_C Cells I6 contains the following formula...

I have written a path to a closed workbook. However it will run the index unless the file is also open. The file takes to long to load and needs to stay closed and allow to be searched in the background. Please help here is the code that shows when the workbook is open. =IFERROR(INDEX('Copy...

I am attempting to create a search where the user enters the search criteria and the return would search an online sheet and return multiple results and columns. Example: Search Dog Results Sam Brown 12 Tested Sam Yellow 15 Not Tested Sam...