VLOOKUP with two searching criteria

[Kristina96]

Hello everyone,

I want to show the status of an ID in the previous period in the same row of today's ID.
The table looks similar to this

A		H		L	M
ID	(...)	Status	(...)	Current period	Previous Period
(...)

In the column next to previous period I want to show the status of the previous period to compare the two. I tried the following:

=VLOOKUP(A2&M2;CHOOSE({1.2};A:A&L:L;H:H);2;0)

But I get an error saying there is no value found. I checked and there is a value for the input I am looking for.

Can anyone help me with that?

Thank you in advance and have a great day everyone!
Kristina

 

[Anthony47]

May I suggest that you share a sample workbook that we may use to better understand the request and test possible solutions?

Bye