Using Sheets, when I input a part number into a cell B3:B7 for a VLOOKUP in G & H sometimes it recognizes the input and sometimes it does not. I’m pulling off of “Shelf Stock” which is an IMPORTRANGE from another sheet.
https://docs.google.com/spreadsheets/d/1v-987Qg1eUH5Hev9NR6HI41GxrUYdb_6Yi37kd0_HIs/edit#gid=604824118