# index formula

1. ### Return "Yes"/"No" when column A = x AND B = y

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...
2. ### INDEX - MATCH - OFFSET - help please

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...
3. ### Index Function returning #VALUE

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...
4. ### Converting Matrix Data to Linear Data for Pivot Table

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...
5. ### SImple INDEX returning #Ref

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...
6. ### Sales lookup comparing day to day

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...
7. ### Index and Match Formula does not sum up...

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...
8. ### Index and Match Formula does not work

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...
9. ### Problem with Formula

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...
10. ### Do not return a zero value with index function

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"...
11. ### Array Formula issue

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<>""...
12. ### Duplicating Index in VBA

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...
13. ### Index/Match usage

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...
14. ### Display blank if not found & if multiple found show in same cell

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...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...