I am using Excel 2007/2010.
I would like to know if there is a formula that would return text values if TRUE based on given criteria.
On sheet 1, I have a tracker that tracks several bits of data.
On sheet 2, I would like to analyze the data contained on sheet 1 based on certain criteria.
I have attached a simple sample excel file of what I am looking for.
Sheet 1 has 3 columns
A: Date
B: Region
C: Name
Sheet 2 has 3 fields of a form
C1: Region (entered manually)
C2: Date (entered manually)
C4: Name (return name if date = C2 and region = c1)
Thanks in advance for your help!
Bookmarks