If Then populate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top