| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to HLOOKUP a value from another sheet and display all the d | Excel Worksheet Functions | |||
| how to display rows of data in a single column | Excel Discussion (Misc queries) | |||
| How do I hlookup a text document object and then display it? | Excel Worksheet Functions | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| how do I display data in rows? | Excel Discussion (Misc queries) | |||
Threaded Mode
