RE: =VLOOKUP(E4,Serial_Prefix,2) Return value in next row.

Can you describe what is in "Serial_Prefix". I assume it's an array of data
defined by a NAME. What type of data is in each column of data and what are
the row/column locations for Serial_Prefix.

"PCLIVE" wrote:

> =VLOOKUP(E4,Serial_Prefix,2)
>
> How can I write this formula so that it returns the value in the very next
> row of what it finds? For example, this formula returns the value in L4.
> How can I alter the formula so that it adds one row to the result, therefore
> returning the value in M4?
>
> Thanks,
> Paul
>
>
>
.

Relevant Pages

  • Re: How to list devices available ?
    ... Short Name: DevNames ... Indicates an array that contains the names of all devices installed in the system. ... Paul ... Prev by Date: ...
    (comp.lang.labview)
  • Re: LabVIEW and C++ Pointers
    ... Like Paul, ... Here I'll tell about an experiences, hoping that it can bring just an idea. ... 2- interpreting the byte array to our complex data structure may be so difficult. ... Prev by Date: ...
    (comp.lang.labview)
  • converting an image into an array of bytes?
    ... can anyone give me some example code that will open a Image file, ... it into a Bytearray? ... Paul ... Prev by Date: ...
    (microsoft.public.pocketpc.developer)
  • Re: large array problem?
    ... Const declaractions. ... have to be examined carefully to insure that it doesn't alter the array ... Prev by Date: ...
    (comp.lang.pascal.delphi.misc)
  • Re: Recursive function - nothing in return values!
    ... What are you trying to do anyway, go backwards thru an array? ... Paul ... Prev by Date: ...
    (php.general)
Loading