Vlookup or your suggestion?

[firstWeMeet]

Hello,

I have the above setup but the Unit price is not working.
this is the formula for the Unit Price =IF(MaterialsDescription="","",VLOOKUP(MaterialsDescription,Table1,5,0)) and got the error? anything solution or suggestion?

 

[pedie]

=IF(MaterialsDescription="","",VLOOKUP(MaterialsDescription,Table1,5,0))

Please check for MaterialsDescription value in table. I think it is missing...

 

[snoopyhr]

Hello,

I have the above setup but the Unit price is not working.
this is the formula for the Unit Price =IF(MaterialsDescription="","",VLOOKUP(MaterialsDescription,Table1,5,0)) and got the error? anything solution or suggestion?

Is materialDescription assigned range in your setup? Have you tried to use the actual cell address rather than range name?

Instead of
=IF(MaterialsDescription="","",VLOOKUP(MaterialsDescription,Table1,5,0))

try this

=IF(MaterialsDescription="","",VLOOKUP(F5,Table1,5,0))

 

[firstWeMeet]

The Crayon is in my table.
Current Total Qty Stock=SUMIF(Table1[Materials Description],Name,Table1[Current Qty])
Unit Price=IF(MaterialsDescription="","",VLOOKUP(MaterialsDescription,Table1,5,0))
Total Stock Cost=SUMIF(Table1[Materials Description],Name,Table1[Total])

check the formula, just the Unit price different to the total qty stock and total cost. so how I set it up? just VLOOKUP or what formula should I set for this Unit Price?

 

[firstWeMeet]

Above is the Sheet1
Materials Description (merge DE5) then the FGH5 merge too which has the data validation, the FGH5 merge cells I named it the "MaterialsDescription" the source of this Sheet1 is in the Sheet2 which in the Table

 

[Dryver14]

I think you should be putting..

=IF(F5="","",VLOOKUP(F5,Table1,5,0)