Vlookup with two criteria

[Sefty]

Hello,
I need help, if I have a case to do a vlookup with 2 categories so that if criteria one is not found then it will be searched for with criteria two.
I want to find "price" with the first criteria "code", if can't find it then look for the second criterion "product".
Please help, what is the Vlookup formula for?
Thank you for help....

Book1
	B	C	D	E	F	G	H	I
1	DATABASE				Vlookup
2	Product	Code	Price			Product	Code	Price
3	Shoes	124	8000			Hat	156
4	Hat	156	12000			Clothes	246
5	Clothes	267	50000			Skirt	500
6	Bag	657	45000			Bag	657
7	Skirt	500	65000			Shoes	780
Sheet1

 

[MARK858]

Seeing as you have 365 then maybe

Book1.xlsb
	A	B	C	D	E	F	G	H	I
1		DATABASE				Vlookup
2		Product	Code	Price			Product	Code	Price
3		Shoes	124	8000			Hat	156	12000
4		Hat	156	12000			Clothes	246	50000
5		Clothes	267	50000			Skirt	500	65000
6		Bag	657	45000			Bag	657	45000
7		Skirt	500	65000			Shoes	780	8000
Sheet1

Cell Formulas
Range	Formula
I3:I7	I3	=XLOOKUP(H3,$C$3:$C$7,$D$3:$D$7,XLOOKUP(G3,$B$3:$B$7,$D$3:$D$7,""))

 

[DanteAmor]

For those of us who don't have 365

Dante Amor
	A	B	C	D	E	F	G	H	I
1		DATABASE
2		Product	Code	Price			Product	Code	Price
3		Shoes	124	8000			Hat	156	12000
4		Hat	156	12000			Clothes	246	50000
5		Clothes	267	50000			Skirt	500	65000
6		Bag	657	45000			Bag	657	45000
7		Skirt	500	65000			Shoes	780	8000
8							Coat	800	does not exist
Hoja5

Cell Formulas
Range	Formula
I3:I8	I3	=IFERROR(VLOOKUP(H3,$C$2:$D$7,2,0),IFERROR(VLOOKUP(G3,$B$2:$D$7,3,0),"does not exist"))

 

[Sefty]

For those of us who don't have 365

Dante Amor
	A	B	C	D	E	F	G	H	I
1		DATABASE
2		Product	Code	Price			Product	Code	Price
3		Shoes	124	8000			Hat	156	12000
4		Hat	156	12000			Clothes	246	50000
5		Clothes	267	50000			Skirt	500	65000
6		Bag	657	45000			Bag	657	45000
7		Skirt	500	65000			Shoes	780	8000
8							Coat	800	does not exist
Hoja5

Cell Formulas
Range	Formula
I3:I8	I3	=IFERROR(VLOOKUP(H3,$C$2:$D$7,2,0),IFERROR(VLOOKUP(G3,$B$2:$D$7,3,0),"does not exist"))

WOW Magic, puzzling solved
thanks a lot Master!!