Index/Match Help

[spcalan]

I figured out the single lookups..
but now I need a double lookup.

I need to look up an employee AND "Strength" to find rating score.
Example : Employee = Alan, Analytical Value of 4

Worksheet: "Overall Strengths"
Column B is Employee Name
Row C ( Specifically C4 : AJ4) has lists of "Strengths"

Worksheet : "Database"
Column A = Employee Name
Column F = "Strengths"
Column E = Is the value I need

 

[Aladin Akyurek]

@ spcalan

Example:

A4 = jon

B4 = 10

These are look up values.

Column A of Sheet1 houses names like jon.
Column B of Sheet1 houses values like 10.

The goal: To get a result from column C of Sheet1 which correspond to the look up values.

Care to do the same?

 

[spcalan]

 

[spcalan]

[/URL][/IMG]

[/IMG]

 

[spcalan]

Let me know if you can see the visuals...

 

[Aladin Akyurek]

Let me know if you can see the visuals...

See post #11 for how to do it.

 

[spcalan]

Got it>.

=INDEX(Database!$E:$E,MATCH(1,(Database!$A:$A=$B5)*(Database!$D:$D=C$4),0))