abhishekkhosla
New Member
- Joined
- Apr 14, 2018
- Messages
- 3
Hi,
I am trying to learn how to use index match function when there is multiple variables. I am getting NA error below is the screen shot can somebody explain where i am going wrong and what i need to be careful when i am using the formula. I am using ctrl+shift+enter to sun this formuls
Forumla : =INDEX(C2:C8,MATCH(1,(F2=A2:A8)*(F3=B2:B8),0))
<tbody>
</tbody>
I need
<tbody>
</tbody>
I am trying to learn how to use index match function when there is multiple variables. I am getting NA error below is the screen shot can somebody explain where i am going wrong and what i need to be careful when i am using the formula. I am using ctrl+shift+enter to sun this formuls
Forumla : =INDEX(C2:C8,MATCH(1,(F2=A2:A8)*(F3=B2:B8),0))
First name | Last Name | Salary |
James | Smith | 64710 |
James | Anderson | 122234 |
James | Clark | 34556 |
John | Lewis | 1223434 |
John | mark | 122323 |
Mark | Reed | 1224354 |
<tbody>
</tbody>
I need
First Name | Last Name | Salary |
James | Clark | ? |
<tbody>
</tbody>