INDEX-MATCH or VLookup for pulling in matching data?

**alexx579** · 04-25-2016, 02:27 PM

Hi All, quick question for you....

In the file attached, I have five columns.

In Column D, I have the information from Column A, just grouped in bunches alphabetically. What kind of formula can I use (in Column E) to return each corresponding "Area" (from Column B)?
.
For example, in Column A, "AB" is listed sporadically 21 times, but I want to be able to put in a formula into Column E to return the corresponding "Area" in the exact order it falls under.

For reasons, I can not simply do a manual sort. Thanks for your help!!

**Kaper** · 04-25-2016, 02:57 PM

In E2 array formula:

Formula:

Please Login or Register  to view this content.

and copy right and down

*...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

**alexx579** · 04-25-2016, 02:59 PM

Thank you Kaper!!!

**Kaper** · 04-26-2016, 01:45 AM

Glad to hear that, and thanks for reputation.
As that seems to take care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.

INDEX-MATCH or VLookup for pulling in matching data?

LinkBack

Thread Tools

Rate This Thread

Display

INDEX-MATCH or VLookup for pulling in matching data?

Re: INDEX-MATCH or VLookup for pulling in matching data?

Re: INDEX-MATCH or VLookup for pulling in matching data?

Re: INDEX-MATCH or VLookup for pulling in matching data?

Thread Information

Users Browsing this Thread

Similar Threads

Index match formula is not pulling the correct data

[SOLVED] MATCH/INDEX Formula Help - Pulling Data

Vlookup or Index/Match only matching the first 8 characters.

[SOLVED] pulling multiple results from one page and putting them on another (vlookup, index match?)

[SOLVED] Help! Vlookup, Index Match match, sumproduct? Matching text with multiple conditions

Trouble with Index/Match and/or Vlookup and mutliple column matching

[SOLVED] INDEX / MATCH / VLOOKUP - returning values from worksheets based upon matching cells

Bookmarks

Bookmarks

Posting Permissions