Page 1 of 1

Excel LOOKUPS

Posted: Sun Dec 21, 2008 5:35 pm
by karankhosla
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!

Posted: Sun Dec 21, 2008 5:36 pm
by karankhosla
Corresponding Excel File!

Posted: Mon Dec 22, 2008 12:32 pm
by bob@vensim.com
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.

Posted: Tue Dec 23, 2008 3:01 pm
by karankhosla
Thank you very much Bob and Season's Greetings!

Posted: Tue Dec 23, 2008 3:04 pm
by karankhosla
Thank you very much Bob and Season's Greetings!