Home » Forums » Open Source Learning Center » Question and Answer

Excel workbook

Submitted by VMR72 on 17 July, 2013 - 00:08

I have an Excel workbook with 2 sheets
I need a formula that will do this;
SHEET 1 E73 = SHEET 2 C62 IF SHEET 1 A3 = AUGUST

‹ counting from 1 to 100,000,000 within 30 seconds, Conditional Formatting ›
»

Excel workbook

Submitted by Jon on 19 July, 2013 - 21:25.

Hi,

Paste the following formula in cell E73 on Sheet1

=IF(Sheet1!A3="AUGUST",Sheet2!C62,"")

Hope this helps

Jon

»