IF(ISNA....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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,
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.
 
Rusty -

Did you get an answer for your vlookup formats question? I have searched
for it and can't find the post - and am trying to do something similar i
believe. trying to have the format lookup as well as the value. Thanks for
any help!!!

Doug
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=IF(ISNA + VLOOKUP? 4
nested if doesn't work 1
Involved VLookup Function 6
Vlookup - ISNA function 4
isna vlookup 2
3 level nested if please explain 1
IF isna to avoid #N/A 5
VLOOKUP more than one instance 1

Back
Top