#### firstWeMeet

##### Board Regular
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?

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

#### pedie

##### Well-known Member
=IF(MaterialsDescription="","",VLOOKUP(MaterialsDescription,Table1,5,0))

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

#### snoopyhr

##### Active Member
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?

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

try this

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

Last edited:

#### firstWeMeet

##### Board Regular
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?

Last edited:

#### firstWeMeet

##### Board Regular

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

##### Well-known Member
I think you should be putting..

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

Replies
3
Views
74
Replies
6
Views
108
Replies
3
Views
109
Replies
6
Views
164
Replies
4
Views
140

1,191,582
Messages
5,987,468
Members
440,097
Latest member
Wint

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back