Trust me, if you followed my instructions, it WILL work. Are you sure your cell is returning a true #N/A result? Did you adjust the cell reference from $A$1 to the cell that has the VLOOKUP FORMULA?

What is your VLOOKUP formula?

Are you applying the CF to the cell with the VLOOKUP formula?

More details, please.