VLOOKUP with two searching criteria

Kristina96

New Member
Joined
Sep 30, 2019
Messages
32
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
AHLM
ID(...)Status(...)Current periodPrevious 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:
Excel Formula:
=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
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Anthony47

Well-known Member
Joined
Mar 29, 2006
Messages
1,969
May I suggest that you share a sample workbook that we may use to better understand the request and test possible solutions?

Bye
 

Watch MrExcel Video

Forum statistics

Threads
1,119,104
Messages
5,576,140
Members
412,700
Latest member
IIII
Top