Vlookup or Index Match on 2 matches

[jmuise2007]

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]

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