Index Match

[ekhawaja]

Hello There!

I am looking for an index match formula that looks up a value for "Eq" from col C in Col A, the Eq value in col A is repeated, and the formula only returns (in col D) the highest numerical value located in col B.

THANKS IN ADVANCE.

A	B	C	D
Eq	Model	Eq	Model
09C-3	4205454​	41HA-400	17008593​
09C-4	29124763​	09C-7	20008593​
09C-5	39124763​	09C-3	29124755​
09C-50	4526932​	09C-4	29124763​
09C-52		09C-5	49124763​
09C-6	10008593​	09C-50	4526932​
09C-7	20008593​	09C-52
09C-3	4205455​
09C-4	20059710​
09C-5	29124763​
09C-50	4526932​
09C-52
09C-5
09C-7	20008593​
09C-3	29124755​
09C-4
09C-5	49124763​
09C-50
09C-52
41HA-400	17008593​
09C-7	20008593​

 

[Fluff]

How about

=MAXIFS(B:B,A:A,C2)

 

[ekhawaja]

How about

=MAXIFS(B:B,A:A,C2)

thanks Fluff for the reply!

the formula seems to be returning 0 on all the cells.....

 

[Fluff]

In that case check that the values in col B are real numbers & not text.

 

[ekhawaja]

It works, thank you so much @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.