I understand that to remove the #N/A's from cells in my lookup I need to use
the IF(ISNA function. Could someone help me out by correctly adding this
function to my lookup formula.
=VLOOKUP($A$17,$D$37:$DV$47,COLUMN(B16)-1,FALSE)
Also, I have a question in a different thread about copying the
formats/formulas from a lookup, using VB. Will this new formula be affected
by the VB?

Thanks for your answers!