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

V

VZW Justin

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.
 
R

RagDyer

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)
 
V

VZW Justin

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?
 
R

RagDyer

Try this:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top