lookup rows and columns

[ashani]

Hi,

I wonder if someone could guide me please.

I have 300 employees sales data for january, Feb March and so on - I would like to use the formula in the front sheet to find out the employee name and that month sales to bring it onto main sheet.

on the front sheet - In Rows A - I have employee Data and in Columns B to Y I have months.

Any help would be much appreciated.

Thank you

 

[kweaver]

I assume you mean in COLUMN A you have the employee name.
If the months are in columns B to Y, that encompasses TWO years (i.e., 24 months).
How do you differentiate?

Would you provide a few examples of what you want to find and then show on the front sheet?

 

[ashani]

Thank you for your reply.
All sorted.