List dependant drop down menu

[Closed]
Report
Posts
1
Registration date
Thursday December 19, 2013
Status
Member
Last seen
December 19, 2013
-
Hello everyone,

I have a worksheet with two columns (A and B) of data. I'm trying to populate a second worksheet (column A) using a drop down box to select the "Project Number" from and change the vertical list based on that selection.

Here is what I have so far just can't seem to get a handle on it.

=IF($D$3="Project Number","",MATCH(D3,GroupNumbers,(OFFSET(DataPMC!$A1,1,1))))

If there additional question please let me know.