Hello guys, is it possible to use the IF.ERROR function together with the REPLACE function?
My problem is, that i want to create an document, where i have 2 pages. One where all the data is stored, ex. barcode and the name of the goods the barcode is on. The other page is supposed to be an page, where i can scan in goods and then place them in a designated storage location.
The problem is, that i want the barcode i scan, to transform in to the name of the goods i recieve! So i want it all to happen in one cell.
IS THIS EVEN POSSIBLE.. ??
