LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posts: n/a
Default 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.
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing a range name as an argument to the Index Function Michael Sharpe Excel Discussion (Misc queries) 3 September 5th 12 01:33 PM
Function to determine if any cell in a range is contained in a given cell [email protected] Excel Worksheet Functions 3 February 7th 05 04:19 PM
Database or list range is not valid JRM Excel Worksheet Functions 2 December 16th 04 12:29 AM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
How do I create a "List If" function.I need to search a database . Flying Solo Excel Worksheet Functions 2 December 7th 04 03:44 PM

All times are GMT +1. The time now is 10:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"