Bernard,
Thank you. Your formula works very well also!
If anyone is comfortable in VBA, you might be able to help me with my
question posted as "copying formats from a vlookup" in the Excel programming
section.

"Bernard Liengme" wrote:

As an alternative to Pete_UK's method, try
=IF(countif($D$37:$D$47,$A$17),VLOOKUP($A$17,$D$37 :$DV$47,COLUMN(B16)-1,FALSE),
"")
Just a little shorter
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"olrustyxlsuser" wrote in message
...
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!