I am using a VLOOKUP to check information from different workbooks. The formula I've written is
=VLOOKUP(A7,'[TWOS RPT 2-07-05.xls]CHRONIC OFFENDERS'!$G$2:$H$70,2,FALSE)
Sometimes the results comes out as #N/A (this is the correct results).
Instead of that error I'd like to get a blank in the cell. What is the best way to accomplish that? Should I nest the VLOOKUP within an IF statement? If so, How?
=VLOOKUP(A7,'[TWOS RPT 2-07-05.xls]CHRONIC OFFENDERS'!$G$2:$H$70,2,FALSE)
Sometimes the results comes out as #N/A (this is the correct results).
Instead of that error I'd like to get a blank in the cell. What is the best way to accomplish that? Should I nest the VLOOKUP within an IF statement? If so, How?