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.
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.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks