Use a function in cell

[mevikasjain]

Use a function in cell shaded with Grey which will search for the Rank from the data shaded in yellow based on the product specified in cell shaded with blue,for
ex: the rank for Product C specified in the criteria should be 3


Rank Product
1 A
2 B
3 C
4 D
5 E
6 F
7 G
8 H


C


Please pls help me...

 

[Andrew Poulsom]

You can use INDEX/MATCH:

http://www.contextures.com/xlFunctions03.html