| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding a value or the one next to it in a range NOT array
Picture data in a phone book with 5 columns of names and numbers 10 cols
total. I need a function that will look up the name and return the number that will work if I don't know in advance which column the name will be in. (they aren't in alpha order). Vlookup and match presume I know which column I am dealing with. Help this has taken many unprofitable hours from my life. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the Location within an Array | Excel Worksheet Functions | |||
| Help in finding Value in Index Array | Excel Discussion (Misc queries) | |||
| Finding the least frequent value in an array | Excel Discussion (Misc queries) | |||
| Finding Data in an Array | Excel Worksheet Functions | |||
| Finding max array value of variable cell range | Excel Discussion (Misc queries) | |||
Threaded Mode
