I have two worksheets on a fie

(#1 Worksheet is entitled Basic)

(#2 Worksheet is entitled Financial Plan)

The Basic worksheet has many columns and some of the data is "Funding Centers", "Purchase Requisitions" & "Purchase Orders"

I run a system called Business Warehouse and it populates these fields of the Basic Worksheet. When data is "Missing" it will show a #N/A in column A of the Basic Worksheet

What I am trying to do is set up an IF Statement on the Financial Plan Worksheet that will read the Basic Worksheet and if there is an #N/A in column A, than it will copy the values from column C, D, E, F & G of the basic Worksheet over to columns B, C, R, S & Q of the Financial Plan Worksheet?

I hope this makes sense??

Thank you!!