If Then populate
 

Good day i am struggling here and need some help fast, i am trying to
populate some cells with data based on certain conditions. If i select
certain Project via drop down menu i want the work sheet to be populated with
data only relative to that Project.
Can anyone help me please with example????
Thanks a million

If Then populate
 

Your description is pretty vague, but a suggestion...

Say your dropdown is in cell A1 of sheet1 and your project data table is
in Sheet2, columns A:J, with the project name in column A (which you
could then use as the list for your dropdown, if you wanted).

Then in Sheet1, enter:

B1: =VLOOKUP(A1,Sheet2!$A:$J),2,FALSE)
C1: =VLOOKUP(A1,Sheet2!$A:$J),3,FALSE)
....
J1: =VLOOKUP(A1,Sheet2!$A:$J,10,FALSE)

Change references to suit.

In article ,
whatzzup wrote:

Good day i am struggling here and need some help fast, i am trying to
populate some cells with data based on certain conditions. If i select
certain Project via drop down menu i want the work sheet to be populated with
data only relative to that Project.
Can anyone help me please with example????
Thanks a million