VLookup Multiple Criteria

jrarmstrong

Board Regular
Joined
Mar 15, 2010
Messages
202
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
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,192
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,001
Messages
5,526,199
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top