Lookup formula HELP!!!

[Sykovampyr]

Hi All!

We are working on a sheet and want to pull data from sheet 2 based on the date entered on sheet 1 cell A1.

The data is arranged on sheet 2 by date. Each cloumn is a different date containing either a staff name in the rows below or off. These are list across 31 columns.

In each row below contains the staff name or "off" if they are out on that day listed by location of work i.e. area one, area two etc. up to 24 areas.

I want to pull this information to a front sheet listed by area of work if the staff name appears then it shows open and if the fourmula returns off then its closed.

Any ideas?

I think i explained it badly!


Thanks,

James

 

[Akashwani]

Hi James,

Can you provide some sample data of Sheet2 and your expected results on your "front" sheet?
You can post sample data by using one of the links in my signature.

Example of sample data....

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	01/07/2013	02/07/2013	03/07/2013	04/07/2013	05/07/2013	06/07/2013	07/07/2013	08/07/2013	09/07/2013	10/07/2013
2	Bill	Bob	Ben	Bud	Dan	Don	Den	Deb	Su	Stu
3	Area One	Area Two	OFF	Area One	Area Three	OFF	Area One	Area Two	OFF	Area One
4
Sheet18

I hope that helps.

Ak