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.