Hlookup a value in a column and display the data 12 rows below.
 

Hello,

I have a lot of data from multiple queries that can only be dumped into 1
colum and spans almost 1000 rows. To make a summary page that makes this data
more user friendly I have an hlookup query the command that was run for a
specific query and it needs to display the result 12 lines down. Each query
is different in length but it always shows the result I'm looking for 12 rows
down.

some sort of an example of the code would that I'm trying to make is:

=HLOOKUP('worksheet data'!A2,'PSLINK Raw Data'!A1:A1000,12,FALSE)

But the ,12,FALSE would need to give the result of 12 rows below the value
from 'worksheet data'!A2 and the next one would be A3, and A4 and so on.

Hlookup a value in a column and display the data 12 rows below.
 

If I understand what you're asking, see if this works for you:

=INDEX('PSLINK Raw Data'!A1:A1000,MATCH('worksheet data'!A2,'PSLINK Raw
Data'!A1:A1000,0)+12)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"VZW Justin" wrote in message
...
Hello,

I have a lot of data from multiple queries that can only be dumped into 1
colum and spans almost 1000 rows. To make a summary page that makes this
data
more user friendly I have an hlookup query the command that was run for a
specific query and it needs to display the result 12 lines down. Each
query
is different in length but it always shows the result I'm looking for 12
rows
down.

some sort of an example of the code would that I'm trying to make is:

=HLOOKUP('worksheet data'!A2,'PSLINK Raw Data'!A1:A1000,12,FALSE)

But the ,12,FALSE would need to give the result of 12 rows below the value
from 'worksheet data'!A2 and the next one would be A3, and A4 and so on.

Hlookup a value in a column and display the data 12 rows below
 

AWESOME!!! Thank you so Much! That worked great.

Would you also be able to advise how to use the wild card in the lookup?

Meaning the text I'm using on the look up is this:

tst:pslnk,vpath=81-71,enh,DELAY; PF

and it may also appear like this:

< tst:pslnk,vpath=81-71,enh,DELAY; PF


Can I make the command you sent me which works perfectly lookup just
vpath=81-71?




"RagDyer" wrote:

If I understand what you're asking, see if this works for you:

=INDEX('PSLINK Raw Data'!A1:A1000,MATCH('worksheet data'!A2,'PSLINK Raw
Data'!A1:A1000,0)+12)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"VZW Justin" wrote in message
...
Hello,

I have a lot of data from multiple queries that can only be dumped into 1
colum and spans almost 1000 rows. To make a summary page that makes this
data
more user friendly I have an hlookup query the command that was run for a
specific query and it needs to display the result 12 lines down. Each
query
is different in length but it always shows the result I'm looking for 12
rows
down.

some sort of an example of the code would that I'm trying to make is:

=HLOOKUP('worksheet data'!A2,'PSLINK Raw Data'!A1:A1000,12,FALSE)

But the ,12,FALSE would need to give the result of 12 rows below the value
from 'worksheet data'!A2 and the next one would be A3, and A4 and so on.

Hlookup a value in a column and display the data 12 rows below
 

Try this:

=INDEX('PSLINK Raw Data'!A1:A1000,MATCH("*"&'worksheet data'!A2&"*",'PSLINK
Raw Data'!A1:A1000,0)+12)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"VZW Justin" wrote in message
...
AWESOME!!! Thank you so Much! That worked great.

Would you also be able to advise how to use the wild card in the lookup?

Meaning the text I'm using on the look up is this:

tst:pslnk,vpath=81-71,enh,DELAY; PF

and it may also appear like this:

< tst:pslnk,vpath=81-71,enh,DELAY; PF


Can I make the command you sent me which works perfectly lookup just
vpath=81-71?




"RagDyer" wrote:

If I understand what you're asking, see if this works for you:

=INDEX('PSLINK Raw Data'!A1:A1000,MATCH('worksheet data'!A2,'PSLINK Raw
Data'!A1:A1000,0)+12)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"VZW Justin" wrote in message
...
Hello,

I have a lot of data from multiple queries that can only be dumped into
1
colum and spans almost 1000 rows. To make a summary page that makes
this
data
more user friendly I have an hlookup query the command that was run for
a
specific query and it needs to display the result 12 lines down. Each
query
is different in length but it always shows the result I'm looking for
12
rows
down.

some sort of an example of the code would that I'm trying to make is:

=HLOOKUP('worksheet data'!A2,'PSLINK Raw Data'!A1:A1000,12,FALSE)

But the ,12,FALSE would need to give the result of 12 rows below the
value
from 'worksheet data'!A2 and the next one would be A3, and A4 and so
on.