Index and Match Functioin

[andere16]

Enter a nested INDEX and MATCH Function in cell K7 that examines the range B6:H25 and returns the corresponding employee information based on the match values in cell J7 and cell K6. Note K6 contains a validation list that can be used to select various lookup categories. Use the Data Validation list in cell J7 to select Rmployee_ID 31461 and select Salary in cell K6 to test the function

I put in =INDEX(B6:H25,MATCH(J7,F5:F25,0),5)

the Salary is in column H (5th)
Dependents in Column F (4th)

Can someone help me figure out what I'm doing wrong

 

[Max1616]

Give this a shot (Assuming the value you are referencing for the lookup is in column F):

=INDEX(H:H,MATCH(J7,F:F,0))

 

[Fluff]

Where does the value in K6 come into it?
Also what column has the employee ID?