Hi - I was able to figure out that it was returning "other" because I had not specified other vs. blank. I updated the formula to =IF(J2="","",IFERROR(VLOOKUP(J2,lookuptable,2,0), "Other")) and I was able to get what I needed. Thanks!