O
olrustyxlsuser
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!
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!