Help with INDEX and MATCH

[pmcleod]

I have been trying this for a while but can't seem to figure it out. Can someone tell me what I am doing wrong? In the attached workbook I am trying to:

Look at a value in tblObjectives|Goal
Find the match in tblGoals|Goal
Return the adjacent value in tblGoals|Perspective

Example: FIND "Integrate Teams" and RETURN "Operations"
Example: FIND "Manage Budgets" and RETURN "Financial"

Thanks for the help

Perry

[Gregb11]

Try this:

=INDEX(tblGoal[Perspective],MATCH(Objectives!C2,tblGoal[Goal],0))

[6StringJazzer]

This will also give the correct result using only table labels:

Please Login or Register  to view this content.

[pmcleod]

Works like magic! Thanks very much!

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.