index / match

Hello, Is there a formula I can put into a cell that will use another cell as a reference, find a match for that number on another sheet, go to the last cell with data in that row, but then return the data from cells to the left of that, ie: -1 or -2. Sheet1: <tbody> reference data (12345)...

I recently changed my spreadsheet from vlookup to Index/Match. I have approximately 2000 rows by 300 columns which all require in vary degrees use of the index/match formula, for example: =IFERROR(INDEX(Orders!$S$1:$S$9999,MATCH(CT$3&$B4&$C4,Orders!$A$1:$A$9999,0)),0) Currently the spreadsheet...

Hi! I'm attempting to sum all values in a table that that 1. match a specific value in a header (column) and 2. match multiple values in the rows (there are about 20 values). Each of the values I want the data to match are referencing cells that contain the value. The below formula I pasted...

Hello, I am using an Index/Match formula and at the last function when I don't want to match the exact value (0 - because it rarely would) or take the lesser value (1 - because it is not as accurate) the formula usually outputs an #N/A! error when I have the input as -1 as to take the greater...

Hi I've always referred to these forums but I was unable to find the direct answer to my question this time so I figured it was time to create an account. The basic idea of what I want to do is to use tag based logic to find the category that meets my specified criteria. At First I was just...

Hello, I am currently using the below formula: =INDEX($B$40:$B$404,MATCH($B$5&$B$11,$C$40:$C$404&$D$40:$D$404,0),1) I am matching b5 & b11 from cascading dependant drop down lists. It works to return the first value I need in column B, but when I copy it down it still returns the same value...

This is a first time post so apologies if i transgress the rules. I am using Office 2013 (64-bit) in a Windows 7 environment. I have written the following nested array of index/match with named ranges to create a cumulative list from several named ranges which reside on different sheets/tabs...

I'm using an index match formula where the index is a named table called "UnemploymentTable" on another worksheet within my Excel workbook (see screen shots below). The trouble I'm having is when I drag my formula to the right, the index/match formula is going to my table and looking up one...

I need an experts advise please. I have a formula that needs to be populated on multiple cells of column G, can someone assist me on how to create a macro to accomplish this? below is the macro for your reference...

Hi all, I am trying to find a way to incorporate wildcards into a number of formulas in Excel 2010 if possible. Basically I have a sheet called "Raw Sales Data" which contains all sales of all items, and on another sheet called "Sales Ledger" I use various formulas to count how many sales...