Vlookup - 2 Cells

[Michael11]

Hello,

I am trying to produce a bill of materials for my work. I have produced a mass list (bill of materials) for this to be broken down unique to the project through vlookup and data validation.

My master bill of materials looks like so;

I have managed to reduce both item and size columns so they so unique values only as opposed to countless D20, D32, etc. I require the 2 cells to total a unit cost as above but I keep getting #N/A. The example below should work out as £2.25.

Any assistance will be greatly appreciated.

Thank you.

 

[Fluff]

How about
=XLOOKUP(A2&"|"&B2,Calc!$A$2:$A$22&"|"&Calc!$B$2:$B$22,Calc!$C$2:$C$22,"",0)

 

[Michael11]

Hello,

Thank you for the reply. I have input the code which then opens the documents folder and leaves cell blank?

 

[Fluff]

You need to change the sheet name to match your sheet name.

 

[Michael11]

Thank you very much, all working.

 

[Fluff]

You're welcome & thanks for the feedback.