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.
--
swatsp0p
------------------------------------------------------------------------
swatsp0p's Profile:
http://www.excelforum.com/member.php...o&userid=15101
View this thread:
http://www.excelforum.com/showthread...hreadid=398687