Vlookup or Index Match on 2 matches

**jmuise2007** · 06-19-2007, 10:51 AM

Hello,

I am new to this board and hope you can help me. I hope I explain this okay.
I have a tab that has a working Vlookup to a tab called 'Channel' returning a 1 with two matches or 0. I need to change this to return a text field - either B1 or B2 from a column on tab called 'Metro'. I tried Index with two matches, no luck. Vlookup - no luck. I am hoping to use index match if possible. The tab called 'Metro' has the same info as 'Channel' but is not, and can not be in ascending order and has many instances of both channel description and "E000129-01" so I believe I need the middle tab.

I've attached the summary data. Please help?!

I've been working on this too long.

**ieatboogers** · 06-19-2007, 08:22 PM

If I'm reading your question correct, you need to return a text field based on two criterias. Can't really tell by your summary data attachment but here's a general answer:

=index(column_to_index,match(cell_with_1st_criteria, if(column_to_index_2nd_criteria=cell_with_2nd_criteria,column_to_index_1st_criteria),0)) CTRL+SHFT+ENTER

i.e.

=index(G$1:G$10,match($A2,IF($F$1:$F$10=$B2,$E$1:$E$10),0))
CTRL+SHFT+ENTER

Vlookup or Index Match on 2 matches

LinkBack

Thread Tools

Rate This Thread

Display

Vlookup or Index Match on 2 matches

index & match functions

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions