| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HLookup indirect multiple worksheets
I need to accumulate the data from 2,000lease + worksheets onto one summary
worksheet. I would like to insert the lease number and use HLOOKUP to populate the summary sheet. I'm not familiar enough with INDIRECT to put it in the formula. I copied the following from another community posting and tried to adjust it for my summary sheet: =HLOOKUP(A5,INDIRECT($A$5&"!$d$4:$h$104"),2,FALSE) The worksheets contain 6 number (e.g. 001500). Can you please help me to write the correct formula to pull each piece of data from the worksheets' columns D through H to the summary sheet? Thanks, Kelly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HLOOKUP using multiple columns | Excel Discussion (Misc queries) | |||
| HLOOKUP with multiple conditions | Excel Worksheet Functions | |||
| Use of Indirect on two worksheets | Excel Worksheet Functions | |||
| Multiple lookup values in =HLOOKUP | Excel Discussion (Misc queries) | |||
| Can vlookup or hlookup look to other worksheets within a workbook. | Excel Worksheet Functions | |||
Threaded Mode
