Greatly appreciate any help with this.

On one worksheet called 'Budget' I have one cell that is the PROJECT field
(B5)

On Column A Rows 19 to 81 is a data validation list field called 'Donor' on
the same worksheet.

The list of Projects and their donors resides on a second worksheet called
'Data'

The list looks like this
Column A Column B
Project Donor
01001 6374
01001 5540
01001 4303
04001 9901
04002 9915
04002 9901


What I am trying to accomplish is when a user enters a project in B5 on
budget worksheet, the donor fields reference that project on the Data
worksheet and list all available donors for the project.

Example:
User enters 04002 project
Donor field shows 9901 on drop down

Thanks





I have an array but it is not working...thanks for the help.