Prev: number of worksheets
Next: Excel 2007 file locked by 'another user' on windows 2008 share
From: boardbug on 5 Dec 2009 15:27
VLookup returns a value in the same row. However, for my purposes I need the
value in a row ahead or a row behind.

So for example if Vlookup formula returns a value in Cell b3, I actually
want to know what it's in the next row i.e. Cell b4 or possibly Cell b2
Does anyone have any thoughts??

Thank you!
From: מיכאל (מיקי) אבידן on 5 Dec 2009 15:38
Index+Match will produce the same result - however, MATCH returns the number
of the cell in the range (not necessarily the sheets ROW() number).
You can add/subtract 1 from the MATCHs result.
Micky


"boardbug" wrote:

> VLookup returns a value in the same row. However, for my purposes I need the
> value in a row ahead or a row behind.
>
> So for example if Vlookup formula returns a value in Cell b3, I actually
> want to know what it's in the next row i.e. Cell b4 or possibly Cell b2
> Does anyone have any thoughts??
>
> Thank you!
From: T. Valko on 5 Dec 2009 16:44
>Cell b4 or possibly Cell b2

Well, you have to narrow it down to one or the other! Or, explain in great
detail under what condition you want B2 and when you want B4.

--
Biff
Microsoft Excel MVP


"boardbug" <boardbug(a)discussions.microsoft.com> wrote in message
news:E42A567C-FD02-4CF8-8DDB-7F3B885AEC1D(a)microsoft.com...
> VLookup returns a value in the same row. However, for my purposes I need
> the
> value in a row ahead or a row behind.
>
> So for example if Vlookup formula returns a value in Cell b3, I actually
> want to know what it's in the next row i.e. Cell b4 or possibly Cell b2
> Does anyone have any thoughts??
>
> Thank you!


 | 
Pages: 1
Prev: number of worksheets
Next: Excel 2007 file locked by 'another user' on windows 2008 share