vlookup help needed

I am using the following syntax.

=VLOOKUP('MIS'!A4:A1000,'Data from MIS'!B4:B1000,A59,FALSE)

I am trying to lookup where 'MIS!A4:A1000' is equal to A59 and return the
contents of the relevant row cell in 'MIS!B4:B1000'

Can someone tell me what I have wrong please

thanks
S

Sorry, my syntax in above was wrong. Iam using:

=VLOOKUP('MIS'!A4:A1000,'MIS'!B4:B1000,A59,FALSE)

"Steven J" <SJ@nospammersajc.co.uk> wrote in message
news:%23avrDVofFHA.3232@TK2MSFTNGP15.phx.gbl...
>I am using the following syntax.
>
> =VLOOKUP('MIS'!A4:A1000,'Data from MIS'!B4:B1000,A59,FALSE)
>
> I am trying to lookup where 'MIS!A4:A1000' is equal to A59 and return the
> contents of the relevant row cell in 'MIS!B4:B1000'
>
> Can someone tell me what I have wrong please
>
> thanks
> S
>
>

=VLOOKUP(A59,MIS!A4:B1000,2,FALSE)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Steven J" <SJ@nospammersajc.co.uk> wrote in message
news:uGRo5bofFHA.2152@TK2MSFTNGP14.phx.gbl...
> Sorry, my syntax in above was wrong. Iam using:
>
> =VLOOKUP('MIS'!A4:A1000,'MIS'!B4:B1000,A59,FALSE)
>
> "Steven J" <SJ@nospammersajc.co.uk> wrote in message
> news:%23avrDVofFHA.3232@TK2MSFTNGP15.phx.gbl...
>>I am using the following syntax.
>>
>> =VLOOKUP('MIS'!A4:A1000,'Data from MIS'!B4:B1000,A59,FALSE)
>>
>> I am trying to lookup where 'MIS!A4:A1000' is equal to A59 and return the
>> contents of the relevant row cell in 'MIS!B4:B1000'
>>
>> Can someone tell me what I have wrong please
>>
>> thanks
>> S
>>
>>
>
>