• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 125
  • Last Modified:


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.

1 Solution
Ejgil HedegaardCommented:
Like this in E2

Open in new window

Only the first row match both Center Name and Store number.
See file with the unique values from XXBA below.
jmac001Author Commented:
Thank you, can do single values, still trying to master multiple criteria.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now