What wrong with VLOOKUP formula

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_index,exact_approximate)

See help, you seem to be using incorrectly

--

HTH

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


"TARZAN" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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