Try this:

=IF(ISNA(VLOOKUP($A$17,$D$37:$DV$47,COLUMN(B16)-1,FALSE)),"",VLOOKUP($A
$17,$D$37:$DV$47,COLUMN(B16)-1,FALSE))

All one formula - beware of spurious line breaks.

Hope this helps.

Pete

On Apr 30, 5:40 pm, olrustyxlsuser
wrote:
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!