#N/A Error Help

[DawnAZ]

I am getting an #N/A error on the following spreadsheet. Can anyone help me with this? The error is on the Ala Cart sheet at the bottom. (F263). Any help is appreciated.

Thanks!

[vlady]

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.

[DawnAZ]

I have used the formual you suggested and it worked. Thank you. I am now however, receiving another error. I have tried =IF(F265<0,0,(F265*G265)) to solve the problem but it is not working. I have attached the spreadsheet. Thank you again.

[Cutter]

Change your formulas to:
=IF(F265="",0,(F265*G265)) if you want zero result when col F value is ""
or
=IF(F265="","",(F265*G265)) if you want "" result when col F value is ""

[DawnAZ]

Thank you! Its fixed :-)

[Cutter]

You're welcome. Glad to hear it.