Put this in the Evaluation sheet cell A2
=IF(TRIM(Schedule!B1)="","",IF(Schedule!B10,Sched ule!A2,""))
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Akash" wrote:

I HAVE TWO SHEETS:

1. SCHEDULE
2. EVALUATION

IN THE SHEET SCHEDULE I HAVE TWO COULUMNS

A B
1. PROJECT NAME NO OF UNITS


IN SHEET EVALUATION I GAIN HAVE TWO COULMNS

A B
1. PROJECT NAME NO OF UNITS

I WANT THAT IF THE VALUE OF SCHEDULE!B1 GREATER THAN ZERO THEN THE CELL
OF EVALUATION!A2 SHOULD REFLECT THE VALUE OF THE VALUE OF SCHEDULE!A1

Right now i am using the below mentioned formulae which is not working.
Me getting an output as 0.

=IF(TRIM(SCHEDULE!B1)="","",IF(SCHEDULE!B10,(EVAL UATION!A2=SCHEDULE!A2)))

What should i do. Where i m lagging. Pls help me in this regards.

Thanks in Advance & wishing you a very happy new year.

Akash