View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Vlookup on 2 columns

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