Help needed with Vlookup code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Help Needed - 21 Jul 2006 09:00 GMT

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?

Signature

Help Needed

Reply to this Message

VBA Noob - 21 Jul 2006 09:13 GMT

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/EED883/VC418316331.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

Signature

VBA Noob

Reply to this Message

Help Needed - 21 Jul 2006 10:28 GMT

Thanks for your help.

Signature

Help Needed

Reply to this Message