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