| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Location in Array
I have a table on Spreadsheet 'A' - O1:S1000. Is there some way to look up a
value from Spreadsheet 'B' in the table on 'A', and return either the row in the table where the value was found, or the column where it was found, or the cell address, or all of the above? -- Bill @ UAMS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Location in Array
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Location in Array
Perfect! Thanks so much.
-- Bill @ UAMS "Herbert Seidenberg" wrote: Here are several way to do it. http://www.freefilehosting.net/download/3afl7 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the Location within an Array | Excel Worksheet Functions | |||
| Finding Location of Maximum Value in 2D Array | Excel Discussion (Misc queries) | |||
| Finding Location of Maximum Value in 2D Array | New Users to Excel | |||
| Finding Location of Maximum Value in 2D Array | Excel Worksheet Functions | |||
| How to return a specific data point from a large array if I don't know the exact location? | Excel Discussion (Misc queries) | |||
Hybrid Mode
