Hi,
I think this must have been answered before but try as I might I can't find an answer anywhere despite it (surely?) being a common requirement.
I'd like to search a table, not just one column, for a value (might be an alpha or numberic value or a mixture) and have returned the value in the first column if the searched for value is found.
Any entry in the table is either blank or unique and there is no instance where there'd be no entry in the first column if there is any entry, in whatever column, to the right in the same row.
For more info: my table actually lists unique project ID's in column 1 and then lists alongside each one or more unique task ID's to indicate which tasks are associated with which project so I'm trying to find a formula that will advise which project a given task is associated with.
Finally if the task ID is not found then I'd like the formual to return the advice "Task ID not associated with a Project".
Can anyone help please?
thanks
Ben
I think this must have been answered before but try as I might I can't find an answer anywhere despite it (surely?) being a common requirement.
I'd like to search a table, not just one column, for a value (might be an alpha or numberic value or a mixture) and have returned the value in the first column if the searched for value is found.
Any entry in the table is either blank or unique and there is no instance where there'd be no entry in the first column if there is any entry, in whatever column, to the right in the same row.
For more info: my table actually lists unique project ID's in column 1 and then lists alongside each one or more unique task ID's to indicate which tasks are associated with which project so I'm trying to find a formula that will advise which project a given task is associated with.
Finally if the task ID is not found then I'd like the formual to return the advice "Task ID not associated with a Project".
Can anyone help please?
thanks
Ben