0

Let's say I've got List:

Security:       Country of Issue:    Currency:
Stock           Greece                USD
Stock           USA                  USD
Option          Great Britain        GBP
Bond            Greece               EUR

I want to find the currency of the stock in Greece. Normally I would use VLOOKUP but I assume it cannot process this request. What other functions are there to find the underlying currency?

user9078057
  • 187
  • 1
  • 6
  • 3
    [Index/Match](https://stackoverflow.com/questions/31965182/using-excels-index-function-with-column-and-match#31965853) sounds like it may do what you want – cybernetic.nomad Aug 13 '18 at 14:42
  • You could use vlookup choose: https://www.myonlinetraininghub.com/excel-vlookup-to-the-left-using-choose – Lowpar Aug 13 '18 at 15:20

0 Answers0