Have row data input automatically when current month selected.

Hi everyone,

New to this forum.

I have a newbie issue that I cannot solve. I have a drop down menu on one worksheet (Performance Indicators) for months of the year and I am trying to get the other cells in the row below it to automatically fill from the "Data Input" worksheet. Not quite sure how to do it. I did create the drop down window from the "Data Input" worksheet but I am stuck from there. I have attached the file for you to see, there is nothing proprietary as it is just a bunch of numbers as place holders for now.


Thanks in advance for the help!

everytime im just ready to post an answer someone else already has

i used a vlookup instead of index, same thing different formula

Formula:

Please Login or Register  to view this content.

Moo, benishiryo, rossg:

Thanks a million..........works perfect.