Solved

INDEX/MATCH CHALLENGE

Posted on 2014-12-19
2
116 Views
Last Modified: 2014-12-19
Hi I am a VLOOKUP user and I know that using Index/match is better to use but I am having some difficult in writing the function.   I have multiple criteria pulling from different worksheets.   In the attached workbook the data source is XXBA and all the data is being populated on the Match worksheet.  The goal is to have 1 row with a center name (based on center name and store #) and then populate the Status Type in column I from XXBA to columns E-I on Match depending on the value.

Could someone help me with this.

Thanks
EE-Index-Match-2014.12.19.xlsx
0
Comment
Question by:jmac001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 22

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 40509949
Like this in E2
=IFERROR(INDEX(XXBA!$I$5:$I$204,MATCH($A2&$D2&E$1,INDEX(XXBA!$B$5:$B$204&XXBA!$E$5:$E$204&XXBA!$H$5:$H$204,,),0),1),"")

Open in new window

Only the first row match both Center Name and Store number.
See file with the unique values from XXBA below.
EE-Index-Match-2014.12.19.xlsx
0
 

Author Closing Comment

by:jmac001
ID: 40509972
Thank you, can do single values, still trying to master multiple criteria.
0

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question