VLOOKUP for multiple items over differnet sheets

[Jaydenmac84]

Hello all I am new here so im sorry if this has been asked and answered but this is what I am looking for.Currently I am using VLOOKUP like this =IF($A8="","",(VLOOKUP($A8,MASTER!$A$1:$G$1500,6,FALSE)))I have changed my master sheet to allow conversions so now I enter the master sheet like thisPlain Flour /25/kg/ Rp100,000.00/ kg/25/ Rp4,000.00/g/25000/Rp4.00 The / signify the next column. Currently I enter plain flour any where else and it will bring the unit and the price over for me, what I want to do is be able to enter plain flour and then either Kg or g and have it look up the price for that item according to the unit???? Im not sure if this is too vague but from what I am trying for example having A4&B4 then the area and then g:m column's on the master but I cant seen to get it to work

 

[Arithos]

Abit unclear on your data. It looks like this?

	A	B	C	D	E	F	G	H	I	J
1	Flour	25	kg	Rp100,000.00	kg	25	Rp4,000.00	g	25000	Rp4.00

<tbody>
</tbody>

And you want to input either grams or kilograms to get the price from a vlookup function?