#indexmatch

Hello I am so glad to find this forum, might question might be super easy for most of you but I am beating my head on a wall from last few hours so thought to register and raise it here I want to Select the month in month total say March it gives me No. 3 and in YTD total is I select Mar 16...

I've been trying to add both iserror and isblank to my index match to give me a text value instead of being blank or an error. Here are the two i have so far that i need to try and combine...

Hi there, I am having no luck with my index match formula. I am trying to create a formula that will match with the following criteria "Apple" and "FY19" to return the number 200. If anyone can help that would be really appreciated. Any suggestions on formulas? <tbody> Opportunity# Apple...

I have a need that I can’t seem to find a resolution to. I need a formula that will look in Training Records workbook, Column E for a name in the Staff List workbook, tab1 Column A. If that name is in both locations, then search all records with that staff name in Training Records...

Hi, I have two lists of Accounts that I need to consolidate. These lists come from two different sources and in a lot of cases the individual names are slightly different. Ie One list has 'AC Nielsen', the other one has 'Nielsen Media'. The best tool I have found so far is a partial Vlookup...

Hello - can you help me with index & match formula. I've tried many times but I can't get it :eeek: I have a large data set that I need to update week as week go by so I need to do an index/ match to return information on another workbook automatically as I refresh the weekly dates...

Hi All, I'm new here and needed some help with excel formula related to index match with 2 criteria and after found the item, get the nearest date base the 2 criteria row date. As this outgoing sheet is continuously updating from day 1. There are some item that will be send out again after...

Hi... I hope someone could show me the right direction here... So, here is my table : A B C D E F G H I J K L M <tbody> ID STORE MILK BREAD MILK ORANGE COFFEE TEA...

Hello all, I'm working in excel 2010 and have been struggling trying to concatenate results to an Index+Match formula. I was forced to use Index+Match instead of Vlookup as the column that I am searching for data in is to the right of the column that I'd like to extract data from. I'm am...

I am trying to use Index Match to pull data totals into a summary sheet. On the detail sheet, I have rows of orders (Order 1,2,3...), the columns have monthly Dates (Jan-15,Feb-15,Mar-15...). Each month with each order has a payments. In the summary sheet I want to put a formula that will...

Hi everyone, I have been doing greater than less than in a HUGE nested AND function, however, I understand that there is a very simple way to do a index + match that will capture greater than (or equal) / less than (or equal). Can you help me to ID if this formula exists? See below for a...

Hi All, I have a formula that is referrencing a closed workbook and returning #ref! error for all but two of the matches. But, the values appear when the source workbook is open. I have tried updating links etc. but to no avail :( Following is the formula I have been using to sum a range...