Help with Vlookup ??

  • Thread starter Thread starter Steve Grosz
  • Start date Start date
S

Steve Grosz

I am trying to use the Vlookup and am having some problems with it.

I have 1 sheet that has my the info I'm search for on 'book1'. Here is
my forumla:

=VLOOKUP(A6,'[Book1]mar page counts'!$1:$65536,2,TRUE)

When I change the column to 1, it actually returns info, if I enter
anything other than column 1, I don't get info back, even though I can
manually search through book for for a value in column A, and find a value.

Any suggestions?

Thanks very much!!

Steve
 
Uzytkownik "Steve Grosz said:
I am trying to use the Vlookup and am having some problems with it.

I have 1 sheet that has my the info I'm search for on 'book1'. Here is
my forumla:

=VLOOKUP(A6,'[Book1]mar page counts'!$1:$65536,2,TRUE)

When I change the column to 1, it actually returns info, if I enter
anything other than column 1, I don't get info back, even though I can
manually search through book for for a value in column A, and find a value.

Any suggestions?

Thanks very much!!

Steve
Click to expand...

vlookup looks for dat in columns
$1:$65536 should be used in hlookup
use for example A:C instead of $1:$65536

mcg
 
Ok, with:

=VLOOKUP(A1436,'[Book1]mar page counts'!$A:$C,2,TRUE)

I still have the same problem, its not picking up the data in the 2nd
column of '[Book1]mar page counts' when I know there's data there.

Steve
I am trying to use the Vlookup and am having some problems with it.

I have 1 sheet that has my the info I'm search for on 'book1'. Here is
my forumla:

=VLOOKUP(A6,'[Book1]mar page counts'!$1:$65536,2,TRUE)

When I change the column to 1, it actually returns info, if I enter
anything other than column 1, I don't get info back, even though I can
manually search through book for for a value in column A, and find a
value.

Any suggestions?

Thanks very much!!

Steve
Click to expand...


vlookup looks for dat in columns
$1:$65536 should be used in hlookup
use for example A:C instead of $1:$65536

mcg
Click to expand...
 
Maybe

=VLOOKUP(A1436,'[Book1]mar page counts'!$A:$C,2,False)


--

HTH

RP
(remove nothere from the email address if mailing direct)


Steve Grosz said:
Ok, with:

=VLOOKUP(A1436,'[Book1]mar page counts'!$A:$C,2,TRUE)

I still have the same problem, its not picking up the data in the 2nd
column of '[Book1]mar page counts' when I know there's data there.

Steve
I am trying to use the Vlookup and am having some problems with it.

I have 1 sheet that has my the info I'm search for on 'book1'. Here is
my forumla:

=VLOOKUP(A6,'[Book1]mar page counts'!$1:$65536,2,TRUE)

When I change the column to 1, it actually returns info, if I enter
anything other than column 1, I don't get info back, even though I can
manually search through book for for a value in column A, and find a
value.

Any suggestions?

Thanks very much!!

Steve
Click to expand...


vlookup looks for dat in columns
$1:$65536 should be used in hlookup
use for example A:C instead of $1:$65536

mcg
Click to expand...
Click to expand...
 
Back
Top