Multiple return Index match or better look up

**Shruder** · 03-21-2019, 07:39 PM

Hello,

here is what I am looking for. This is a small sample of data. I need a look up function that will only return the data from column B on Database 2 tab. Testing this formula or maybe something similar?

Please Login or Register  to view this content.

There are going to be same account numbers where I only want to return the values in column B of second tab. I don;t think Vlookup will work but if there is a multi Vlookup, maybe?

Any ideas? Sample file attached

Capture.PNG

**jeffreybrown** · 03-21-2019, 07:44 PM

I think you are looking for...

=IFERROR(INDEX('Database 2'!B:B,MATCH(A2&"|"&B2,'Database 2'!A:A&"|"&'Database 2'!B:B,0)),"")

...in C2 copied down on tab Database 1

IMPORTANT

This is an array formula
Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
If entered correctly, the formula will be enclosed in {brackets}
Do not enter the {brackets} manually

**azumi** · 03-21-2019, 08:09 PM

Another option with non array formulas, put this on C2 and copied down until blanks:

=IFERROR(INDEX('Database 2'!$B$2:$B$4,MATCH(1,INDEX(('Database 2'!$A$2:$A$4=A2)*('Database 2'!$B$2:$B$4=B2),),0)),"")

**Shruder** · 03-22-2019, 06:19 PM

@azumi that formula works, thanks

Multiple return Index match or better look up

LinkBack

Thread Tools

Rate This Thread

Display

Multiple return Index match or better look up

Re: Multiple return Index match or better look up

Re: Multiple return Index match or better look up

Re: Multiple return Index match or better look up

Thread Information

Users Browsing this Thread

Similar Threads

INDEX MATCH MATCH and return MAX value of multiple matches

Return Multiple Match Values in Excel Using INDEX-MATCH

Help with index and / or match formula with multiple match required to return a value

[SOLVED] Index/Match with Multiple Criteria and Multiple return values

[SOLVED] Match Index to return multiple values

Using Index/Match to return multiple values for one match

Can Index or Match return multiple results?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions