Help needed with Vlookup code

[help-needed]

I have noticed other vlookup codes in excel and after looking at them have started to try and use them myself.

2 questions.

1) The codes i saw had a lot of $ signs in them. I dont use them when i use vlookup and it seems to work fine. Is there a reason $ signs are added?

2) I have a vlookup code "=VLOOKUP(A9,Database!A1:F8000,2,FALSE)" and so on for a few lines and when it finds a blank box it puts 0 in there to represent that. Is there a way i can have it so that instead of putting a zero in it just leaves the box blank?

[VBA Noob]

Hi

You need the Absoulte $ symbols to fix range the vlookup range. If you drag your foumla down it will start to look at A2:F8001 instead of A1:F8000. In the foumla bar slect range and press F4.

More info on attached link

http://www.bettersolutions.com/excel...C418316331.htm

If vlookup can't find a match it will return #N/A. To get around this enter

=IF(ISNA(VLOOKUP(A9,Sheet2!$A$1:$F$8000,2,FALSE)),"",(VLOOKUP(A9,Sheet2!$A$1:$F$8000,2,FALSE)))

VBA Noob

[help-needed]

Thanks for your help.