Is there a way to final a number in excel

[jschill2628]

I have four lines of data that I need to pull out.

Example
FY10 FY11 FY10 FY11
0501 94 25 $5,000 $3,000
St. Mary 94 25 $5,000 $3,000
IN 34 10 $4,000 $1,000
MO 60 15 $1,000 $2,000


I need to pull out the information in this. I want to pull it and not rearrange the data, because next time I have to update the data, I just want to copy and paste the information.

So is there a way to say: if a cell equals 0501, then find IN underneath it (2 down) and return 34?

I am using Excel 2003.

Thank you!!

 

[Madawc]

Is this an Excel question in the wrong forum? Or are you using Excel as a source for Crystal.

Crystal allows all sorts of totalling, including running totals and variables that can be conditional. The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP