Excel lookup on multiple rows/columns

[zucchini123]

Hi, i try to build a table which contains rows with a list of name (A,B,C,...aa,bb,cc..etc) and columns as every Sun of 2009

Requirement: Cell for 'A' and cell for 'aa' cant have data at the same date (column), same goes for B to bb..C to cc...etc

xx '1st Sun' '2nd Sun' '3rd Sun' '4th Sun' ............
A data
B
C data
aa data
bb
cc data

Is there any way to use vlookup/hlookup to verify, (what i want to do is to put it into the data vertification, so once i had data in A "1st Sun", and will block me insert data to aa "1st Sun")

Thanks.

 

[knight00779]

Possible Solution 1
With an assumption from the problem description,
if A - Date Value needs to be checked on with aa - Date column, then since two cell are fixed, you can use the below
if(B1=E1,<if true then action>,<if false then action>)

Where,
B1 - is date column of A,B,C section
E1 - is date column of aa,bb,cc section


Possible Solution 2
If the above does not address your problem, then you need to confirm my understanding
Is that you have 1st Sun as a value which needs to be looked in the Array of A,B,C section of Date column, and also look at Array of aa, bb , cc section of Date column and then for A & aa the date column should not be the same.

Hope this helps
Rgrds
Manohar