I'm trying to use the vlookup function. I've got a sheet in the workbook that lists all the item numbers and their corresponding square footages.

I'm trying to look up data on another sheet based on that table. (but I did try putting the table on the same sheet, in case that was it and it didn't help.)

Sometimes it pulls the correct answer and sometimes it doesn't. On the sheet with the list, the table range is B2:C38. On the table I'm trying to use the vlookup function, this is the formula I'm using:

if(d5="","",vlookup(d5,Item!B$2:c$38,2))

Please help! I already made sure every cell is set to number on all sheets, that didn't help. I even tried shortening the digit number, b/c the item number is fairly long (e.g. 10007171), but that changed which cells were messing up, but not the main problem itself.