Ventana software support forum

Posted: **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!

Posted: **Sun Dec 21, 2008 5:36 pm**

Corresponding Excel File!

Posted: **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.

Posted: **Tue Dec 23, 2008 3:01 pm**

Thank you very much Bob and Season's Greetings!

Posted: **Tue Dec 23, 2008 3:04 pm**

Thank you very much Bob and Season's Greetings!

Ventana software support forum

Excel LOOKUPS

Excel LOOKUPS