Hi, could someone please help with the following? I need to undertake a
three-way lookup.

I need the user to select an Operation and Task Group and for Excel to
lookup any instances where the Operation and
Task Group selected has a matching value in column X containing the
text: "VACANT".

If so, then I need the entire record (entire row) to be copied to a new
workbook named: Report on worksheet named:
Report on c:\ drive.

The actual three-way lookup needs to be performed on worksheet named:
Data. Column B contains the Operation data and column C the Task group
data and column X the Position Status data.

The actual user input is performed on another worksheet (in the same
workbook) named: Report. From this worksheet, the user selects the
Operation from the drop-down list at cell B2 and selects a Task Group
from the drop-down list in cell B4.

Operations has a defined name = Operations!$A$2:$A$12.

Task Group has a defined name = Groups!$A$2:$A$29.

Any help with this would be greatly appreciated.

Kind regards,

Chris.



*** Sent via Developersdex http://www.developersdex.com ***