Linking cells based on selection from another cell
Hi,
i have data in two sheets(same file) both the sheets have certain common data like name, employee ID etc.
I want to pull certain data from sheet 2 based on what i have selected in a particular cell in sheet 1
I have put employee name in rows and months in column and have data corresponding to each employee for that month.
and when i select a mont from a drop down list in sheet 1, i want to have the corresponding data of the same employee and month as in sheet 2
HOW DO I DO THAT ???
Help would be really appreciated.
MacBook Pro, OS X Mavericks (10.9.4)