You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

Lookup 2 possible values within INDEX/MATCH function.

Lookup 2 possible values within INDEX/MATCH function.

Price: FREE

Have a formula that works fine.
Problem has arisen that calls for looking for 2 possible values in the range. The formula is posted below:
Composite $C$3:$C$534 (at the end of the formula)
If I could modify that range to include both "Red", or "Blue" in that column it would work. .
OR,
modify the cell to be looked up ($Q3) to include "Red" or "Blue".
=IF(ISERROR(INDEX(Composite!$J$3:$J$534,MATCH(1,(AD$2=Composite!$A$3:$A$534)*(AD$1=Composite!$E$3:$E $534)*($R3=Composite!$D$3:$D$534)*($Q3=Composite!$C$3:$C$534),0)),"",INDEX(Composite!$J$3:$J$534,MA TCH(1,(AD$2=Composite!$A$3:$A$534)*(AD$1=Composite!$E$3:$E$534)*($R3=Composite!$D$3:$D$534)*($Q3=Com posite!$C$3:$C$534),0))
TIA for any ideas on this.

Visit publisher's web-site: Lookup 2 possible values within INDEX/MATCH function.

Category and Tags: ExcelTutorials :

Related Tutorials

Lookup Problem with Index and Match

Free: Yes
Tags: Excel ›

I am trying to get the following working using the lookup function. it works fine as it is shown however I have tried entering the lookup function referencing it from cell 'A5' but cant get it to work. Can anyone help by showing me the correct method.
Mike
=INDEX('12'!$B$2:$R$47,MATCH($D$1,'12'!$A$2:$A$47, 0),MATCH(1,IF('12'!$B$2:$R$2=$D$6,IF('12'!$B$4:$R$ 4=$A$3,1)),0))

Lookup using INDEX and MATCH, having problems with formula

Free: Yes
Tags: Excel ›

I'm having problems troubleshooting a formula to lookup values, getting an error and stuck
The worksheet is self explanatory, values to lookup and value to return are well identified in it.

Which is better? LOOKUP or INDEX?

Free: Yes
Tags: Excel ›

I have data that's 50 some odd columns wide and about 500 rows deep. Is there a more efficient method of looking up values using either a LOOKUP function or an INDEX function? I'm asking because I notice Excel starts to lag when I use VLOOKUP with such a large amount of data and I want to know if it would be worth my time changing it to a INDEX/MATCH function. Does one or the other work quicker?

How can I lookup when match has more than one value?

Free: Yes
Tags: Excel ›

I am using LOOKUP functions to retrieve info from a list. Some of the lookup values have more than one match in the list. Is there a function that allows me to retrieve multiple elements for one lookup value, or at least a function that tells me there are duplicate matches?

index,match - how to avoid same lookup when duplicates present

Free: Yes
Tags: Excel ›

I want to lookup values where duplicates exist but do not want the same lookup result.
e.g.
How can I use Match, Index to return 1 when looking up 12, then 3 when looking up 12, what happens now is I lookup 12 and get 1 every time. I've used pivot tables and that works but its not ideal.

Related Applications & Scripts

JavaScript Web Safe Colors

Free: Yes
Tags: JavaScript › Excel Miscellaneous

A small tool to aid with the selection and conversion of Web Safe Colours. Select from the 216 web safe palette or enter your own HEX/RGB colour values to find the closest match. Also converts HEX to Decimal RGB values and vice-versa.

Lookup Runner: Search stores, hotels, atms

Free: No
Tags: PHP › Excel Zip Code Locators

Lookup Runner is a PHP script to help you run zip code locator section at your website.
Lookup Runner allows your website visitors provide a zip (postal) code, then it searches for dealers, stores, hotels, restaurants, ATMs, etc, within a certain distance of this zip code.
Looking for store locator script? Lookup Runner searches within specified distance range and returns approximate distance to matching locations. One of the key benefits of Lookup Runner is the ability to work with almost any country - we provide zip code information.
We constantly add new features and options to provide the dependable store locator software solution at reasonable price

Space Match Memory game - Advanced

Free: No
Tags: Flash › Excel Games

In this space style memory game you have to flip tiles over to match two icons. Flipping over all the tiles ends the game.
This game features a timer and the game remembers your time for the session you are in. The game also has sound.
This is the advanced version of this file. It has the following features:
- PHP compatible saving to text file (.txt)
- ASP compatible saving to tex tfile
- Level select
Easy, Medium and Hard
- Individual scores for each level
- Sorts scores by best time

Flash Creations: Flash Ultimate Gallery

Free: No
Tags: Flash › Excel Software

This is the perfect tool to share your photographs via the web. Create stunning Flash photo albums from your favorite digital pictures. Simply select the digital photos you care to show, add the captions, and post it to your site....it's that easy! Plus, you can have numerous galleries to organize the photos for your friends and family. And, it is guaranteed to match your website! All the colors are changeable by you. The headline is changeable, the title can change, the outlines, all of it available to change any time.

Multi-thread Simulation in PHP

Free: Yes
Tags: PHP › Excel Classes Performance

This class can emulate the execution of program threads using separate HTTP requests to the same script. It establishes an HTTP connection to the same Web server to execute the same PHP script. It sends a request passing the name a function to execute and an argument to be passed to that function. The requested script executes some code that detects the thread execution request and calls the specified function. When the thread request script ends, the return values of the called function is returned as a serialized string. The calling script can execute other tasks while the thread script runs. The results may be collected later when the thread script ends.

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing