CODEWITHSUNDEEP
excelexcel-formula
Rodrigues silva
Rodrigues silva

Reputation: 87

Excel- Find value in table

How to find the corresponding value in the table?

The first one worked, but I tried to replicate it to the others and give the error.

enter image description here

Upvotes: 0

Views: 471

Answers (1)

Vin
Vin

Reputation: 1037

This formula in E2 (then dragged down to E3, E4 and E5) should give you what you want:

=INDEX(A2:C2,MATCH(D2,$A$1:$C$1,0))

That should give you this:

enter image description here

Is that what you were after?

Upvotes: 3

Related Questions