vlookup like function

[cselefendi]

hi everyone!

I'm trying to do a simulation with the following structure and ran into a problem on how to do a vlookup like task.

I am trying to compute c = s(t, i) * p(t, i, j),
where c is consumption, t is temperature, i and j are time-of-year and time-of-day variables.

The s() and p() functions' values are given in a matrix: for each t (row) and i and j (colums) the value is given.
I have 1000x618 simulations for t, so I'm looking for a fast way to compute c for each t, i and j variations.

In Excel I would use vlookup functions on the matrices but cannot find a suitable function in EViews.

The data looks like the example file uploaded.

Can somebody help me, please? I would appreciate this very much!
Thanks in advance.

Best,
cselefendi

[EViews Gareth]

Not sure I understand what you're trying to do.