index function

I am trying to use the areas portion of the Index function to select between two different ranges: =Index((CarRange,TruckRange),1,,$A$1) CarRange and TruckRange are defined ranges. They resemble: $B$2:$Z$2 and $C$3:$T$3. They are rows of data of different lengths. In my case, CarRange and...

Hello, I am attempting to create a "peer" pivot table = PVT2(H5), based off the filter selection in PVT1(cell E5). My plan is to use a combo box to have the user select a school to review in PVT1, and by doing so they could view that school's peers(all other schools except the one selected) in...

hi guys, I would be extremely grateful for any support in solving this problem. In short I have created a cube of data, it is a series (Sx300, Px5,Tx50). S = simulations, p=portfolio and t is time horizon. In short it is a series of 300 stochastic simulations for each portfolio for each year. I...

Kindly help me solving searching problem in excel. I have to copy and past following detail from one sheet to another. For Example i have list of 1200 sites with name and description,numbers and other details in next columns A1 to A1200 Sites IDs B2 to B1200 other info....... i have to take...

Hey all, I've been trying to get a formula working based on several examples I've seen elsewhere but I'm getting no dice. Here's the situation: I have a table I'm trying to fill in with data that is coming from another tab. The original data is a list with two columns - one has ID numbers...

Need help... I have two worksheets, sheet1 contains a column of consecutive entries in A1:A20 and sheet2 has 20 groups of data in 13x13 grids with a grid label in the upper left portion of each grid. Grid 1 fills A1:M13, grid 2 fills A14:M26, etc. The grid label is in A1,A14,A27, etc. I am...

I'm new here so good day all! Could do with a bit of assistance if anyone has time? I have tried searching Google and these forums for an answer I could apply to the situation ... Ie. Inside these threads: ...but I'm not quite getting the logic behind this Index match...

Hi, I'm new to the Excel board, but I'm hoping you guys can help me out. I need to find a way to calculate employees' sales for the last 3 months on a rolling basis. I think I want a function that looks for the column that matches "current month," offsets by -2 columns, and then sums from...

Hi, I want to know how to make the array/reference part in an index-match formula look to another cell that in turn looks to a column. My formula is =INDEX('Sheet1!$AU$27:$AU$284,MATCH(A30&B30,'Sheet1'!$G$27:$G$284&'Sheet1'!$H$27:$H$284,0)) For the array reference - 'Sheet1!$AU$27:$AU$284 i...

Hello, Every week I receive a report (always 16 columns, same file name, new rows added every week) that I analyse using a pivot table, using the same filtering set up every week. In Excel 2010, I want to build a "Master Pivot" that will refresh automatically with the new data.To do so I have...

Using Excel 2007, I am trying to utilize the INDEX function directly within the Series Value box for charts. I watched your Youtube video and successfully created a defined names that contained the formula: ='IS History'!$E$117:INDEX('IS History'!$117:$117,(COUNT('IS History'!$117:$117)+4))...

I have been working on this for days and have searched and searched. Of the forums where I have found help this has been the best. I have two columns of data: Name: Performance Value: A 1 B 2 C 0 D 2 E 5 F 6 G 3 In another spot I am...

I'm trying to search an array for a specific value and then return all instances in the array. =index(Sheet1!C48:D77,SMALL(IF(Sheet1!J48:J77="Gold",ROW(Sheet1!J48:J77)),ROW(1:1)),1) If I use the following function it returns a value correctly...

Hi, I have the following problem: I have two workbooks in Excel with the first stating time series information about a company, for example the revenue of the company broken down by country (in rows), i.e. Caribban, Panama, Macau and then total; while the years are stated in columns i.e. I...

I am using Index() and Match() to populate a header on one worksheet (called "Master") with information from another (called "Programs") like so: =INDEX(Programs!$A$13:$AJ$250,MATCH(Master!$A$11,Programs!$A$13:$A$250,0),COLUMN(E$14)) A11 is a data validation cell with a drop down menu...

I need to pull a value from one sheet and put it on another based on a range of 1-40. In column F I have F4:F43 (Total 40). In Column A I have A4:A43 (Total 40). What i need to do is return the value from A to a separate sheet based on the value in F. This is made difficult because currently...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

I am using =INDEX($A$1:$R$1,MATCH(MIN(A7:R7),A7:R7,0)) to find the minumum number in the array. How do I display the value one position greater? I need to order the numbers and titles in increasing order. also any way to ignore the 0 vakues in the cell in the MIN function?

Search and combining row and column data <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I have been working on this with one other guy for the majority of the day and wondering if anyone has any insight. <TABLE style="WIDTH: 319pt; BORDER-COLLAPSE...