Help with homework

Don't want to give too much away too quickly and short circuit your learning process. This looks to me like some kind of lookup function would work, so I will start by pointing you to your help file's list of lookup and reference functions: https://support.office.com/en-us/art...__toc309306714 I would assume that your lesson prior to this homework assignment included some discussion of some of these lookup functions. Which of these functions are you familiar with, and what have you been taught about them?

On edit: I would also suggest a more descriptive title for this thread, especially since you have a different question posted in another forum under the exact same title.

They teach Excel in school?

My goodness. Just image how good I would be at Excel if it had already been invented when I was in school.