Thanks again. I downloaded your test file, and found you are setting the rngLookup to a single cell. But I am using a range of cells (from row 11 to the last used row). When I change yours to use a similar range as mine(rows 8-22), I get the '#N/A' again in the cells.

Perhaps since I am not as familiar with Excel, I might not be using this function properly? The code does seem to do what I need it to do as it is, and pretty quickly, aside from this one issue. If I can't make a change to the Lookup line to fix this, can I run another function on the range afterwards to 'cleanup' the cells which have the 'N/A'?

Again, I thank you for your patience and assistance.