vlookup with multiple lookup values

[cowsarethebest2]

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

 

[fairwinds]

Welcome to the board!

Try:

=LOOKUP(2,1/((A2:A7=F3)*(B2:B7=G3)*(C2:C7=H3)),D2:D7)

Book1.xls
	A	B	C	D	E	F	G	H	I
1	Size	Material	type	Price
2	1	a	q	100		Size	Material	type	Price
3	1	b	w	200		2	b	q	400
4	2	a	q	300
5	2	b	q	400
6	2	c	w	500
7	3	d	q	600
Sheet3

 

[cowsarethebest2]

cool that works really well

thanks!

 

[shephardfamilyenterprise]

cool that works really well

thanks!