I have the following formula:

=VLOOKUP($B2,'Sheet 2'!C$1:C$771,5,'Sheet 2'!E$2:E$771)

for this case:

Sheet 1 Sheet 2

A B C D A B C D
E F G H I
XXX ? ? ? XXX 2 1 3

What's wrong?
I got VALUE!


--
Thanks

VLOOKUP takes the form

=VLOOKUP(value_to_lookup,range_to_lookup,column_in dex,exact_approximate)

See help, you seem to be using incorrectly

--

HTH

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


"TARZAN" wrote in message
...
I have the following formula:

=VLOOKUP($B2,'Sheet 2'!C$1:C$771,5,'Sheet 2'!E$2:E$771)

for this case:

Sheet 1 Sheet
2

A B C D A B C
D
E F G H I
XXX ? ? ? XXX 2 1 3

What's wrong?
I got VALUE!


--
Thanks

Is this what you wanted?

=VLOOKUP($B2,'Sheet 2'!C$1:E$771,3,0)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"TARZAN" wrote in message
...
I have the following formula:

=VLOOKUP($B2,'Sheet 2'!C$1:C$771,5,'Sheet 2'!E$2:E$771)

for this case:

Sheet 1 Sheet
2

A B C D A B C
D
E F G H I
XXX ? ? ? XXX 2 1 3

What's wrong?
I got VALUE!


--
Thanks