Formula, index match

[shijieleong]

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. 

[atcodedog05]

Hi @shijieleong 

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 : )

[TheOC · Accepted solution]

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

[shijieleong]

hi @TheOC 

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

[TheOC]

hey @shijieleong 

No problem! Glad i could be of help!

Cheers,
TheOC

[shijieleong]

hi @atcodedog05 

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. 

[atcodedog05]

Thanks @shijieleong 

After seeing @TheOC workflow and your explanation I was able to understand what was the expected output. With your first question, it wasn't really clear to me hence I couldn't answer 😅.

If you have any other requirements I will be happy to help 🙂 see you around 😀

[atcodedog05]

Hi @shijieleong 

Here is an optimized and cleaned up workflow maybe it might be helpful to you 🙂

Hope this helps : )