The issue with the analysis of data

[VladimirN]

As a source of initial data, I use Excel files. When trying to find the values in the table by using "hlookup" function is working for a file "Data 1" and does not work in the case of the data from the file "Data 2". Why?

With "Data 1":

With "Data 2":

[MikeArmstrong]

Is this what you wanted to do?

Mike

[MikeArmstrong]

Here's another version using lookup.

Mike

[MikeArmstrong]

Remember hlookup looks in the first row of a matrix.

From the help:

hlookup(z, A, r) Looks in the first row of a matrix, A, for a given value, z, and returns the value(s) in the same column(s) in the row specified, r. When the value(s) are returned, they appear in a vector, starting from the left.

Mike

[VladimirN]

No, I do not need other approaches to solving this problem, as it was seen from my first screenshot I found a workaround. I only had to deal with the "hlookup" function. Thanks.

[StuartBruff · Accepted solution]

VladimirN. wrote:

As a source of initial data, I use Excel files. When trying to find the values in the table by using "hlookup" function is working for a file "Data 1" and does not work in the case of the data from the file "Data 2". Why?

With "Data 1":

With "Data 2":

Just to add to what Mike's written (I haven't looked at his worksheets yet), for Data 1, hlookup tries to find 1 in the first row of Результаты_тензометрии, which it does in column 1.  The  match function returns 126, so hlookup then returns the value in row 126 of column 1.

However, in Data 2, 1 doesn't occur in row 1 (only 13 and 4.39 are in row 1), so it flags an error up.

Stuart

[VladimirN]

Yes, I missed in the initial data "1". Thank you.

[StuartBruff]

пожалуйста, нет проблем, владимир

Stuart