# VLookup Multiple Criteria

#### jrarmstrong

##### Board Regular
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

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
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?

Hi,

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

Thanks,

James

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)),"")

Thank you Aladin, this works perfectly. Much appreciated

Thank you Aladin, this works perfectly. Much appreciated

You are welcome. Thanks for providing feedback.

Replies
4
Views
189
Replies
9
Views
155
Replies
0
Views
229
Replies
7
Views
157
Replies
1
Views
433

1,207,012
Messages
6,076,148
Members
446,187
Latest member
LMill

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back