Table Lookup Function Help

[rubyneedshelp]

Hello! I'm trying to write a function (and i'm very new to lookups, which i'm assuming is what I want) to automatically return a result on table I have in the spreadsheet based on the length of time someone was hired and their role. I'm afraid I have confused myself with so much Index, Match, various lookups and i'm not really sure which one (or combination thereof) i'm supposed to use.

For example, my first line for Chris is a Green Team guy with our company for 31 months, which means he falls into the 25 months category for their Quota, so what I want the function to return is the result of 950.
The second line, Jamie is Red Team with us for 5 months, so she falls into the 4 months category for their Quota, and the result should be 250.

I appreciate your time and assistance!

[protonLeah]

Please Login or Register  to view this content.

[rubyneedshelp]

This is perfect!

If I may, can I ask the purpose of the *1 after D2 reference? I see it is necessary but so I understand and if I need to duplicate in the future, what does it do?

[protonLeah]

The data in column D are text/character strings, not numbers; the table data is numeric.
It's jut one of the ways to covert the text values in column D to numerics.

[rubyneedshelp]

The data in column D are text/character strings, not numbers; the table data is numeric.
It's jut one of the ways to covert the text values in column D to numerics.

Got it, thank you!