Can anyone offer a fix please for a VLOOKUP problem I am struggling to resolve? :confused:
I am using a look-up table in "Book 2" to add the text value "YES" to columns on three different Sheets in "Book 1". I am then replacing the "#N/A" with "". Then using:
.SpecialCells(xlCellTypeConstants...