vlookup with multiple lookup values

cowsarethebest2

New Member
Joined
Sep 21, 2006
Messages
2
hi newbie here,

I have a table of pipe prices. Pipes have 3 categories - size, material, type.

I wish to enter the size, material, type in another workbook and have the price for the specified pipe come up.

I've tried nesting the vlookup function but can't get it to work. I've seen something about using the indirect function too.

any help appreciated
thanks
 

Some videos you may like

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.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Welcome to the board!

Try:

=LOOKUP(2,1/((A2:A7=F3)*(B2:B7=G3)*(C2:C7=H3)),D2:D7)
Book1.xls
ABCDEFGHI
1SizeMaterialtypePrice
21aq100SizeMaterialtypePrice
31bw2002bq400
42aq300
52bq400
62cw500
73dq600
Sheet3
 

Watch MrExcel Video

Forum statistics

Threads
1,114,096
Messages
5,545,926
Members
410,713
Latest member
TaremyLunsil
Top