No announcements

### Index Match formula problem

Good morning, I have a formula that doesn't work: =INDEX(1:1048576,MATCH(O1,A:E,0),MATCH(O2,5:5,0)) The ...
| 2 Replies | 484 Views | Created by pete6256 - Friday, November 6, 2015 2:07 PM | Last reply by pete6256 - Friday, November 6, 2015 5:39 PM

### What is the DAX equivalent of this excel formula to find the max (highest alphabetically) value in a text column

I am trying to do the following but in PowerPivot, not a standard Excel formula. Can anyone ...
| 2 Replies | 1024 Views | Created by Maracles - Friday, January 9, 2015 4:56 PM | Last reply by Maracles - Friday, January 9, 2015 6:52 PM

### Index Match using wildcard

Hi Team, Hope you are well. I need some assistance please. I have got the below Index Match Formula which works fine ...
| 1 Replies | 532 Views | Created by Chaz1010 - Wednesday, November 5, 2014 12:32 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Thursday, November 6, 2014 5:52 PM

### Complex excel formula.

columns to Sum the sales data, but I couldn't get it to work. This was the foruma I tried: =(OFFSET(INDEX('Sheet2'!A:A,MATCH("Beverages",Sheet ...
| 2 Replies | 1396 Views | Created by pete6256 - Wednesday, July 25, 2012 1:55 PM | Last reply by pete6256 - Wednesday, July 25, 2012 2:45 PM

### FInd the max qty

Index function to return the value of model range You can refer to formula below to achieve the ...
| 5 Replies | 947 Views | Created by Lenoj - Thursday, January 23, 2014 7:01 AM | Last reply by Lenoj - Thursday, January 30, 2014 12:16 AM

### Need Code for Copy & paste into specific cell (HLOOKUP & VLOOKUP) or INDEX, MATCH

- like a VLOOKUP ) and column E14:AH14 (Drivers - like HLOOKUP). I know there is something like and INDEX, MATCH, but I am not too familiar with using such ...
| 1 Replies | 7211 Views | Created by tonka-toy - Tuesday, June 15, 2010 1:00 PM | Last reply by sudarshans1 - Wednesday, August 18, 2010 8:28 AM

### How to delete formula from cells and keep the values in Excel VBA

Hi, In my Excel I have 15 columns. In column F which has a formula (INDEX MATCH), it has contains "RECEIVED" and "INTRANSIT". I ...
| 3 Replies | 4041 Views | Created by Lenoj - Tuesday, January 13, 2015 6:12 AM | Last reply by ryguy72 - Saturday, January 17, 2015 11:00 PM

### INDEX MATCH Formula Help

I've been trying to create an Excel formula and for some reason the formula isn't cooperating. The objective of the formula is to match an employee ID ...
| 0 Replies | 365 Views | Created by Brian Piedlow - Monday, October 19, 2020 1:29 PM

### index and match

; I want data to go with every entry I make on the first worksheet to the next automatically and get summed up. please help it how to do with formula like index ...
| 3 Replies | 513 Views | Created by dockhem2 - Friday, July 11, 2014 12:58 AM | Last reply by George Hua - Monday, July 14, 2014 8:31 AM

### Excel 2013 VBA: Index/Match Does Not Show a Match Between WkShts

By the way, this is Sheet1 the Address List (the 1st tab in the wkbk) column D is where the Index/Match formula goes:
| 4 Replies | 1008 Views | Created by 123Group456 - Wednesday, October 18, 2017 9:57 PM | Last reply by 123Group456 - Monday, October 23, 2017 10:34 PM

### Dropdown List - Display from 1 column but store value from another

Enter this formula in a cell =INDEX(HowDetailsIdx,MATCH(F5,HowDetailsDescr,0)) Note that, in this case, the formula that returns the ...
| 2 Replies | 2289 Views | Created by Garth Edwards - Monday, January 9, 2012 2:30 AM | Last reply by Ed Ferrero - Monday, January 9, 2012 4:02 AM

### How to assign the result of a formula to a variable and then use that variable in another formula

searches and found the Evaluate function which I can get to work in other situations, but not with an INDEX/MATCH formula.  This is what I ...
| 3 Replies | 7322 Views | Created by Alex Bernauer - Sunday, May 19, 2013 3:54 PM | Last reply by TomChandler - Tuesday, May 21, 2013 12:53 AM

### Index / Match Macro

I have the following Index_Match formula: =INDEX
| 4 Replies | 710 Views | Created by E.Hanna - Thursday, October 12, 2017 6:28 PM | Last reply by E.Hanna - Friday, October 27, 2017 7:02 PM

### Unknown Syntax in Index/Match formula

Hello: I'm revamping a worksheet that I inherited, and came across this formula (Not VBA) for looking up values as an alternativfe to ...
| 2 Replies | 545 Views | Created by RichLocus - Saturday, August 3, 2019 10:56 PM | Last reply by Subodh Tiwari (Neeraj) sktneer - Sunday, August 4, 2019 10:00 AM

### If Cell empty enter formula.

The formula should be a string enclosed in double quotes, and double quotes within the formula should be doubled: .Formula ...
| 3 Replies | 2304 Views | Created by Matt Ridge - Monday, May 7, 2012 1:19 PM | Last reply by Hans Vogelaar MVP - Monday, May 7, 2012 8:42 PM

### Need a calculated column formula to read from another list

I thought this might help. Here's how I would do this in Excel if the two lists were two tables: The ServiceDescription column in the main sheet would ...
| 7 Replies | 28983 Views | Created by rlntel - Tuesday, February 12, 2013 4:14 PM | Last reply by rlntel - Friday, February 15, 2013 2:57 AM

### MATCH () with multiple conditions (mb VBA needed)

Seems, needs universal macro, or the optimal formula "MATCH ()" for big data
| 2 Replies | 541 Views | Created by Aramera - Friday, December 25, 2015 5:11 PM | Last reply by David_JunFeng - Tuesday, December 29, 2015 9:20 AM

### Use If, Index, Match and Vlookup in single formula.

In N2: =IFERROR(INDEX(\$B2:\$K2,MATCH(N\$1&"*",\$B2:\$K2,0)),"") Regards, Hans Vogelaar (http://www.eileenslounge.com)
| 2 Replies | 219 Views | Created by Ahmed Morsyy - Monday, July 9, 2018 6:58 AM | Last reply by Ahmed Morsyy - Monday, July 9, 2018 8:17 AM