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?

[TABLE="width: 736"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Flour[/TD]
[TD="align: right"]25[/TD]
[TD]kg[/TD]
[TD]Rp100,000.00[/TD]
[TD] kg[/TD]
[TD="align: right"]25[/TD]
[TD]Rp4,000.00[/TD]
[TD]g[/TD]
[TD="align: right"]25000[/TD]
[TD]Rp4.00[/TD]
[/TR]
</tbody>[/TABLE]


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