vlookup help

G

Gerd

I have 50 rows in which I get data from a separate
worksheet. Most of the time my query will result in less
than 50 rows of data. My problem is that every row that
I do not require data on has cells filled with #N/A. Is
there a way that I can get rid of these unwanted
contents? Thank you.
 
J

John Wilson

Gerd,

Yes, change your formula(s)

IF(ISNA(yourformula),"",yourformula)

John
 

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

Need Help with a VBA subroutine 0
Cell data entering slow! 0
Space at end of multi page list to accommodate new entries 1
Help with conditional formatting in Excel 2010 8
Counting Cells by Format 2
Using IF and VLOOKUP for range of cells 5
Worksheet(s) open to last used row 5
Multiple VLOOKUP lookup values 1

Top