I am using this formula within a Google Sheets cell to search and match the barcode I am looking for:
The reason this isn't working, is because N2 is another formula:
I know if I convert the N2 formula to value, then it will work. For example, this works just fine:
This does add an extra step in which I need to go in and convert formula result to value. And I was wondering if there was a more automated option of converting formula result to value?
If I added the value manually, it works properly: