Hello

you're receiving #N/A 'coz there's no value in Column E..you can use iferror to display blank.

=IFERROR(VLOOKUP($E263,'Item Cost'!$A$2:$F$105,6,0),"")

use this also in your other formula..that' receiving other errors.