If Statement

[wilcor]

Working with two sheets in same workbook.
Sheet 1 data input
Sheet 2 Report using data in Sheet 1

Problem:

If Col B3, sheet 1 = 20, I want the TEXT in B1, Sheet 1 to store in A2 of sheet 2.

Any help will be greatly appreciated.

[Barrie Davidson]

On 2002-03-08 07:05, wilcor wrote:
Working with two sheets in same workbook.
Sheet 1 data input
Sheet 2 Report using data in Sheet 1

Problem:

If Col B3, sheet 1 = 20, I want the TEXT in B1, Sheet 1 to store in A2 of sheet 2.

Any help will be greatly appreciated.

Put this in A2 of Sheet 2

=IF(Sheet1!B3=20,Sheet1!B1,"")

I assume you want nothing if B3 in Sheet1 doesn't equal 20. If my assumption is wrong let me know.

Regards,