Re: vlookup help needed

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Steven J" <SJ@xxxxxxxxxxxxxxxxxxx> wrote in message
news:uGRo5bofFHA.2152@xxxxxxxxxxxxxxxxxxxxxxx
> Sorry, my syntax in above was wrong. Iam using:
>
> =VLOOKUP('MIS'!A4:A1000,'MIS'!B4:B1000,A59,FALSE)
>
> "Steven J" <SJ@xxxxxxxxxxxxxxxxxxx> wrote in message
> news:%23avrDVofFHA.3232@xxxxxxxxxxxxxxxxxxxxxxx
>>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
>>
>>
>
>


.

Relevant Pages

  • Re: Hyperlink field code
    ... maybe I still haven't understood the syntax correctly. ... Folder, Excel Subfolder). ... Entering hyperlink fields can be tricky. ... Files), click the Bookmark button, and select the range from the ...
    (microsoft.public.word.docmanagement)
  • Re: Need to make a vbs, but dont know how....
    ... Im not really sure that I can verify the syntax and im getting a syntax ... I dont think I have a vbscript editor, I usually use notepad, but I ... What setting do you want to change in Excel? ...
    (microsoft.public.excel.programming)
  • Re: Application.UserName Question
    ... That's formula, not VB, syntax. ... Chip Pearson ... Microsoft MVP - Excel ...
    (microsoft.public.excel.misc)
  • Re: if >= to, then...
    ... Did you try to use John's SQL syntax? ... Microsoft Access MVP ... "Duane Hookom" wrote: ... I'm transferring a very complex file from excel into Access, ...
    (microsoft.public.access.queries)
  • Re: =IF statement
    ... IF uses the syntax ... Nick Hodge ... Microsoft MVP - Excel ...
    (microsoft.public.excel.misc)