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

 

[cerfani]

So are you grabbing a rating score for each strength in C4:AJ4?

you didnt explain but if you create an array formula you can lookup based on Strength and name... i assume strength is some string value in COLUMN C...

{=INDEX(Database!E:E,MATCH(1,(Database!A:A=B2)*(Database!F:F=C2),0)}

 

[Aladin Akyurek]

Care to exactly specify the B cell and the C cell of Overall Strengths, housing the values you want to look up?

 

[spcalan]

Yes.
Looking up the employee name and strength and returning the value.

This makes sense ( i had to do a small modification)
=INDEX(Database!E:E,MATCH(1,(Database!A:A=B:B)*(Database!F:F=C4),0))

breakdown:
Database Column E is the score
Database Column A is the Employee Name that will match
Database Column F is the "Strength"Field

The name is the worksheet is "Scorecard
Column B is the Employee Name
Range C4:AJ4 is the list of "Strengths""

How can I upload a photo of the worksheet ?

 

[cerfani]

press print screen when you want to take a screen shot
open microsoft paint
paste (your screenshot is in the clipboard)
Crop
Save
www.imgur.com upload
then post here and use the insert image button... then paste the imgur link to the image file... ex. www.imgur.com/kjhgsk.jpg (notice this is a link to an image file, not some webpage)

 

[spcalan]

Maybe this helps:

Scorecard Column B = Employee Name - - - -- Database Column A
Scorecard Range C4:AJ4 = "Strengths""------- Database Column D
Value in in Database Column E

 

[spcalan]

https://imgur.com/a/KsfQmbE

 

[spcalan]

Thanks guys for helping.

 

[meenanke]

Note that you'll have to hold down CTRL+SHFT+ENTER to activate the array function

 

[cerfani]

https://i.imgur.com/y4lqAXC.jpg
https://i.imgur.com/2wXnHfi.jpg

you posted the wrong url, those are your images... now you use the insert image button...