Reply to thread

Message: [QUOTE="joeu2004, post: 7404778"] Ostensibly: =IF(OR(H3="",H3="NO PART"),"",...) However, some of the cells in column H that appear blank actually contain one or more spaces. Ideally, I would suggest that you find out why and try to avoid that. Alternatively, the following seems to work with your data: =IF(OR(TRIM(H3)="",H3="NO PART"),"",...) The #REF errors are because you reference column 13 of the lookup table, but the lookup table has only one column. Change $C$1:$C$4138 to $C$1:$O$4138, to wit: VLOOKUP(H3,'Equipment List'!$C$1:$O$4138,13,FALSE) The OR(TRIM(H3)="",...) logic above will remove some #N/A errors as well as some bogus results. The remaining #N/A errors arise because the equipment number in column H does not appear in column A of worksheet "Equipment List". Correct that either by fixing the equipment numbers in column H or by adding equipment numbers to that table in "Equipment List". Alternatively, since you are using Excel 2007 or later (xlsx file), you can do the following if you do not require Excel 2003 compatibility: =IFERROR(IF(OR(TRIM(H3)="",H3="NO PART"),"", VLOOKUP(H3,'Equipment List'!$C$1:$O$4138,13,FALSE)),"") If you do require Excel 2003 compatibility, you will need to do the following: =IF(OR(TRIM(H3)="",H3="NO PART"),"", IF(ISNUMBER(MATCH(H3,'Equipment List'!$C$1:$C$4138,0)), VLOOKUP(H3,'Equipment List'!$C$1:$O$4138,13,FALSE),"")) [/QUOTE]