I'm still confused but I guess that's a function of my age but how about this
for a guess:-

Looking for 11 in colimn A and Ric in Column B and returning column C does
this work?

=INDEX(C1:C10,MATCH(11&"ric",A1:A10&B1:B10,0))

It's an array so enter with Ctrl+Shift+Enter.

Mike

"YeahWiwl123" wrote:

I would like to return the "ric" in col C for each col A value,

thanks
--
yeah wiwl


"Barb Reinhardt" wrote:

What value are you trying to return from column C? IT's not clear from your
question.

Barb Reinhardt



"YeahWiwl123" wrote:

I'm trying to return one value from col C given cols A & B. Data looks like:
A B C
11 isin IDXXXXXXX
11 ric XXX.XX
11 sedol XXXXXX1
11 ticker XXXX
22 isin IDXXXXXXXX
22 ric XXX.XX
22 sedol XXXXXX2
etc. etc.

I can't manipulate the original data and must find col C given col A's value.

I hope someone can help
thanks
--
yeah wiwl