Matching


Posted by Nick Laul on February 15, 2001 10:13 AM

I have a list of 10 currency names and corresponding currency values associated with them. Is there a formula that I can type in a cell that looks up the currency value corresponding to the currency name I use. Example, USD has value = 100, Euro has value = 150. When I create a new list, how do I get the new list to look up the corresponding values for these currencies (and automatically update when I update the master list). Thanks.



Posted by Aladin Akyurek on February 15, 2001 11:06 AM

Did you try constructing a lookup table and applying a formula with the function VLOOKUP to retrieve the desired values.

BTW, "Euro has value = 150" with respect to what?

Aladin