VLookup Multiple Criteria

[jrarmstrong]

Hi,

I am struggling with this and would appreciate some guidance.

I have a table where column A contains a numeric reference number, column B the name of a part, column D the price and column F either an "F" or a "U".

What I would like to do is to do a Vlookup (or equivalent) to find the name of a part (there will be many entries with the same name) with the highest reference number where there is an F in column F and return the value in column D.

Is this possible?

Thanks,

James

 

[Aladin Akyurek]

Hi,

I am struggling with this and would appreciate some guidance.

I have a table where column A contains a numeric reference number, column B the name of a part, column D the price and column F either an "F" or a "U".

What I would like to do is to do a Vlookup (or equivalent) to find the name of a part (there will be many entries with the same name) with the highest reference number where there is an F in column F and return the value in column D.

Is this possible?

Thanks,

James

A houses reference numbers.
B houses part names.
D houses price.
F houses either an F or a U.

What is the look up value we have to go after - just a part name? If so, in which cell do we have this value?

 

[jrarmstrong]

Hi,

It is just the part name and will be in R1.

Thanks,

James

 

[Aladin Akyurek]

Hi,

It is just the part name and will be in R1.

Thanks,

James

Control+shift+enter, not just enter:

=IFERROR(INDEX($D$2:$D$400,MATCH(MAX(IF($B$2:$B$400=$R1,$A$2:$A$400)),$A$2:$A$400,0)),"")

 

[jrarmstrong]

Thank you Aladin, this works perfectly. Much appreciated

 

[Aladin Akyurek]

Thank you Aladin, this works perfectly. Much appreciated

You are welcome. Thanks for providing feedback.