P
Peter
All,
Scenario:
My Table_array has 10 different countries in column A (eg, United Kingdom),
10 different, respective, three lettered currency abbreviations in column B
(eg, GBP).
I need to be able to enter the first five letters only, of one of the
countries into cell C1 (which would represent the Lookup_value) and get cell
D1, which has the VLoopup formula, to throw up the column B's respective
three letter currency abbreviation.
Eg,
Col A Col B Col C Col D
Country Currency enter 5 letters VLookup result
United Kingdom GBP unite GBP
Japan JPY
France EUR
Germany EUR
I've tried =VLOOKUP(C1,A1:B4,2,FALSE) with no joy.
Basically, I need a lookup formula that will find a value from a part-value
search.
Thanks.
Peter
Scenario:
My Table_array has 10 different countries in column A (eg, United Kingdom),
10 different, respective, three lettered currency abbreviations in column B
(eg, GBP).
I need to be able to enter the first five letters only, of one of the
countries into cell C1 (which would represent the Lookup_value) and get cell
D1, which has the VLoopup formula, to throw up the column B's respective
three letter currency abbreviation.
Eg,
Col A Col B Col C Col D
Country Currency enter 5 letters VLookup result
United Kingdom GBP unite GBP
Japan JPY
France EUR
Germany EUR
I've tried =VLOOKUP(C1,A1:B4,2,FALSE) with no joy.
Basically, I need a lookup formula that will find a value from a part-value
search.
Thanks.
Peter