vlookup with dynamic field

Hi I am trying to recreate the Excel vlookup function in Alteryx, but I can't figure out. Need some help. Thanks.

Here is vlookup I use in Excel : =IF(A2="Jan",VLOOKUP(B2,[Jan]Jan!$A:$D,C2+1,0),IF(A2="Feb",VLOOKUP(B2,[Feb]Feb!$A:$D,C2+1,0)))

Here are 3 sample excels files :

Jan and Feb files have detail sales information for each ID each metric ID.

I would like to put Jan and Feb information into summary files.

Jan File

Feb file

Reporting

Accepted answers

Actually, I was thinking about your requirement. I think I know what you need:

The output:

I have created a solution for you:

Keep in mind that you will need to adjust this formula to make it work fo you.

Please mark my post as a solution if this was helpful!

I may mislead you from my last post.

Actually I would like to get sales number from Jan and Feb files and put into summary file.

In the summary excel file, I used the vlookup formula as below. But I can't figure out how to do it in Alteryx. (I just began to use Alteryx)

Month	ID	Metric ID	Sales
Jan	AAA	1	=IF(A2="Jan",VLOOKUP(B2,[Jan]Jan!$A:$D,C2+1,0),IF(A2="Feb",VLOOKUP(B2,[Feb]Feb!$A:$D,C2+1,0)))
Jan	AAA	2
Jan	AAA	3
Jan	BBB	1
Jan	BBB	2
Jan	BBB	3
Feb	AAA	1
Feb	AAA	2
Feb	AAA	3
Feb	BBB	1
Feb	BBB	2
Feb	BBB	3