Hi Bernard,

Thanks for the reply! I ended up using Index and Match instead of
Vlookup since I needed to return the value of another cell. At the end
of it all my formula looks like this:

=IF(ISNA(MATCH( <item_searching_for , <column_looked_in ,
0)),"",INDEX( <sheet_looked_in ,MATCH(<item_searching_for ,
<column_looked_in ,0),8))

In English: Find for item in a column of Sheet1 in a column of Sheet2
(Match function returns a row #). If it returns an error, then it's
not found and return a blank. If it returns a row #, then give me cell
contents at the intersection of that row # and a constant column.

=IF(ISNA(MATCH('IS Inv'!J2,Temp!K:K,0)),"",INDEX(Temp!
$1:$65536,MATCH('IS Inv'!J2,Temp!K:K,0),8))


This appears very complicated and I'm sure it can be broken down into
an easier and shorter formula, but it works for me! I hope this helps
anyone else who is doing a similar process.

Thanks again Bernard, for pointing me in the right direction.
Joel