No Unit Price For Materials

Hello,

On the Lookup Invoice sheet I am not getting the UNIT PRICE for Materials from the Materials sheet.

Can someone please figure out why not?

Thank you so much,
bj

You're formula is in row 20, but you are looking up a value from E22 which is empty.

Thank you MarvinP but the price isn't matching the Unit of Measures in the Materials sheet. The price should be $85.00 for the Driveway Sealer.

I hope this can be adjusted.

Also there may be prices from the Labor sheet for those.

@Fluff13 you found my issue thank you.

In cell G20:

=IFERROR(IFERROR(INDEX(Table1[[LT1]:[LT5]],MATCH('Lookup Invoice'!B20,Table1[CODE],0),MATCH('Lookup Invoice'!$E$13,Table1[[#Headers],[LT1]:[LT5]],0)),INDEX(Table2[[Cubic Yard]:[UOM5]],MATCH('Lookup Invoice'!B20,Table2[Code],0),MATCH('Lookup Invoice'!$E20,Table2[[#Headers],[Cubic Yard]:[UOM5]],0))),"")

You're welcome & thanks for the feedback