Page 1 of 1

Indexing with a Table

Posted: Fri Jan 24, 2020 10:14 am
by geoanstats
I have a table with ISO codes in one column and a value in another. I want to loop through ISO codes and then lookup the value, essentially like a VLOOKUP function in Excel. Essentially;

for %iso USA

!index = **find the row that the USA is in on the table**

string wanted_value = Table(!index,3)

next

Re: Indexing with a Table

Posted: Mon Jan 27, 2020 9:48 am
by EViews Gareth
You just have to loop through the rows one at a time to find the entry you want.