| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiple lookup value's
Is it possible to have multiple (or at least 2) lookup values where the
lookup vector would be spread across multiple spreadsheets. Hypothetical formula: =lookup(D1,D2,'Sheet1:Sheet9'!A2,'Sheet1:Sheet9'!A 4)€¦.or put another way: D1=the appropriate worksheet and D2=the vector within that sheet. Pardon the rookie question but any input would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| Return Multiple Results with Lookup | Excel Worksheet Functions | |||
| How to sum values in multiple worksheets | Excel Worksheet Functions | |||
| Multiple X-Axis Values | Charts and Charting in Excel | |||
| Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
Linear Mode
