index formula

Hello All, I have been pulling my hair trying to figure out a formula that would work. Here's my issue: I have a database that keeps track of all material purchase for any specific day. Each material type is assigned a code. I have another worksheet that keeps track of the "selling" price of...

Hello, My first post here on Mr. Excel and total Excel noob. I'm trying to create a formula where it will return a yes/no when looking up phone numbers in 2 different columns to see if they exist together within the same row. The gist is that I have call detail records where column A is the...

I have a list of Representatives that report to a specific Supervisor who then reports to a specific Manager. (see ex: below) <TABLE style="WIDTH: 180pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=240><COLGROUP><COL style="WIDTH: 77pt; mso-width-source: userset...

Good afternoon, I have a worksheet that needs to populate an account number based on a unit number. I have a separate sheet with all of the account numbers listed. I have my formula written as such in A1: =INDEX(B1, AcctNoLookup!A1:A22,0) The value in B1 is: CD892 (cd892 is preceeded...

I have a matrix table with weight and miles as my table axes. I am trying to create a pivot table so that I can group the weights and miles into broader categories but cant do that (i don't think) until I can get the weight and miles into columnar format. I can't figure out how to get the...

Hi, My range: F3 = Monday F4 = Tuesday . . F9 = Sunday The formula's I tried: =INDEX(F3:F9,3,6) returns #Ref =INDEX(F3:F9,ROWS(3),COLUMNS(6)) returns Monday (it's what I was expecting at intersection 3, 6) =INDEX(F3:F9,ROWS(4),COLUMNS(6)) returns Monday. Expecting Tuesday at intersection...

I am trying to create a formula that will look up sales. I would like it to be Saturday to Saturday and here is the problem. Jan 1 2010 was a Friday, were Jan 1 2011 is a Saturday. How do I create a formula that looks up and matchs Jan1 2011 Saturday to Jan 2 2010 Saturday and then displays...

http://www.box.net/shared/88vj8y987u Hi. I have an index and match formula on the workbook above, however I need the formula so that it will add up the total value. For Example. On the consignment stock sheet in Y45, it says 5000 as it has match up the value of 92979 on the Stock out sheet...

Hi guys, Can anyone work out why my Match and Index formula doesn't work on the stock in consignment worksheet. http://www.box.net/shared/88vj8y987u The relevent PO's are meant to match up to the part no in the stock in consignment sheet and show how many parts have been moved out from which...

http://www.box.net/shared/0ebhd83tg6 Hi Guys So heres what I want to do. I need to link up the PO's and part values on the Stock out and relevant values to the corresponding PO's on the Consignment stock sheet. (It makes sense when you look at the workbook) For example Column B on the...

I am using the following formula to extract the data I need for a chart =INDEX(AF$16:AF$38,$A$2) How can I have this formula not return a zero value if the cell it's referring to is blank? It is plotting the zero for a data point in my chart. I have the chart set on "show empty cells as"...

I'm combining two formulas that I have intergrated into workbook. I'm cleaning everything up so I would like to have the two formulas calculating in one cell, so this is what I came up with: =INDEX(Food_Items[Item],SMALL( IF($AM$3<>"", IF($C$2<>""...

I'm working on automating a project. I have an excel template which matches our web form that I use to test the calculations in our online system and to test calc changes, "what ifs". I extract the data set for all school districts state-wide and want to pull this information from this tab to...

Hi, I am addicted to the combined Index/Match formula for pulling data from one place to another. There is one thing that drives me crazy... how to drag the formula across with an increase in the column number to pull data from. Example wanting to pull data from sheet 1 to sheet 2 on...

Issue 1: Index finds multiple values but only displays one. I'd like it to combine the results in the cell Issue 2: If the match is not found the result is #N/A. I'd like it to be blank Data: Year Domain SubDomain Application Release Unit Test Defects Rank Integration Defects Rank 2007 Domain1...