Formula, index match

Hi all , i have a question here regarding index match in excel,

i have set of client with different target and the target will be depends on the no.of month.

previously i using index match in excel to match the variable 1. no.of month 2.target. as the month moving, the target will be change monthly too.

Attached my workflow, for your advise. thank you.

Preparation

Accepted answers

hi @shijieleong

Not sure if i've misunderstood the task, but i think i have created what you want:

Please find attached as a workflow and let me know if i can help further.

Thanks,
TheOC

Is this what you are looking for

If not can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

hi @shijieleong

Not sure if i've misunderstood the task, but i think i have created what you want:

Please find attached as a workflow and let me know if i can help further.

Thanks,
TheOC

The outcome is my expected result. thanks for the solution.

hey @shijieleong

No problem! Glad i could be of help!

Cheers,
TheOC

my expectation is at the table of client , will lookup for the table with no. of month and the target according to the target tier.

eg. client 29966, as at 28 Feb 22 is the 1st month, tier is 1000, so we will lookup the target to get the target which will be 660 for this client.