I cant wrap my head around this error, I have 2 excel sheets, I am using VLOOKUP to add new pricing from the new sheet to the old sheet, I have triple checked a couple of numbers and noticed some exists on both sheets. Yet I it inputs #NA in that cell, I have cross checked a few numbers and saw that the data is visibly on both sheets. What am i doing wrong?
Formula: =VLOOKUP(D2,[Book1]Sheet1!$A$2:$E$139,5,FALSE)
Formula: =VLOOKUP(D2,[Book1]Sheet1!$A$2:$E$139,5,FALSE)