| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Function that filters a list (Database) for criteria in a range a.
I need to extract an unknown value from a field in a record based on the
location of a known field in the same record adhock (could be the first record, could be the 5th, or the nth record.) : Dorm: Delta Tau LName | FName | Mentor | Age | Sport | ... Davy | Jacob | Samuels | 12 | | ... Johnson| Sheila | Little | 14 | | ... Adams | Arney | Jackson | 13 | | ... ....where the unknown value for the field (Sport) resides in a list (Database) of ALLCAMPERS on another worksheet. The desired criteria for the search is the range LName:FName of the record. I tried using DGET(Database, "Sport", LName:Arney) for the first record in the new list (Dorm: Delta Tau) and got an error. I can use it to return the first record field value for "Sport" by restricting the criteria range to the fields and 1st record, but can OLNY get the first record. the 2nd record returns a #NUM error and the rest of the records return a #VALUE error. Thanks for looking at this. -- FirstVette52 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
| Function to determine if any cell in a range is contained in a given cell | Excel Worksheet Functions | |||
| Database or list range is not valid | Excel Worksheet Functions | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| How do I create a "List If" function.I need to search a database . | Excel Worksheet Functions | |||
Linear Mode
