Excel LOOKUPS

karankhosla · Post by **karankhosla** » Sun Dec 21, 2008 5:35 pm

Greetings,

Attached is a basic Vensim model with the Excel spreadsheat. How could I instruct the XLS LOOKUPS function to read "down" instead of across. "Country No." is my independant variable.

Thank you very much!

karankhosla · Post by **karankhosla** » Sun Dec 21, 2008 5:36 pm

Corresponding Excel File!

bob@vensim.com · Post by **bob@vensim.com** » Mon Dec 22, 2008 12:32 pm

You use 'A' instead of '1' as the third argument to GET XLS LOOKUPS - you also need to tell it the sheet name 'Sheet1' as the second argument. Check the documentation.

karankhosla · Post by **karankhosla** » Tue Dec 23, 2008 3:01 pm

Thank you very much Bob and Season's Greetings!

karankhosla · Post by **karankhosla** » Tue Dec 23, 2008 3:04 pm

Thank you very much Bob and Season's Greetings!