Gets the last value in the row provided that the names match and blanks are ignored

[sofas]

Welcome . Please help me obtain a formula that enables me to get the last value in the row provided that the names in columns A and H match. I was using the following formula, which in turn actually fetches the last value, but without matching or searching for the name in column H.


=LOOKUP(2;1/(B2:E2<>"");B2:E2)

 

[Cubist]

Isn't it the same thing you posted earlier today?

Extract the last value in the row with a condition

Welcome. Please help in extracting the last test that was completed, subject to the subject number, so that when writing the subject number in column (H), the name of the last test with a value in column (i) is obtained. It does not matter, whether by formula or vba code.

www.mrexcel.com

 

[sofas]

Isn't it the same thing you posted earlier today?

Extract the last value in the row with a condition

Welcome. Please help in extracting the last test that was completed, subject to the subject number, so that when writing the subject number in column (H), the name of the last test with a value in column (i) is obtained. It does not matter, whether by formula or vba code.

www.mrexcel.com

No, the previous topic is somewhat different. It fetches the column header. Now I need to get the value of the last row

 

[sofas]

Isn't it the same thing you posted earlier today?

Extract the last value in the row with a condition

Welcome. Please help in extracting the last test that was completed, subject to the subject number, so that when writing the subject number in column (H), the name of the last test with a value in column (i) is obtained. It does not matter, whether by formula or vba code.

www.mrexcel.com

Oh my God, thank you. I didn't really notice. I tried to modify the formula and it actually worked