I have two spreadsheets. I am scanning items onto sheet 2 under column A.
On Sheet 1 I have all the information for Inventory. The Columns I will be using from sheet a is Column D and Column AA. So when I am scanning items on sheet to and a number from Column AA matched from Sheet 1 it will pull the information from Column D from the same row and be put in column C on sheet 2. I have a formulas but its not pulling the information needed

Not Found appears but there are matches
=IF(A2=””, “”, IFERROR(VLOOKUP(A2, Woo!$D$2:$AA$1000, 4, FALSE), “Not Found”))