Getting 2 columns of data into a new column depending on a status

[beneldridge]

Hi,

I am trying to get data from 2 columns and put the data into a new column depending on the criteria/status from another column:

Example:

Column 1 - Status    

Column 2 - Budget Hours

Column 3 - Delivered Hours

Column 4 - NEW Column

If the status in column 1 was "Delivered" or "Closed" or "Historic" I would like the NEW Column to pick up the hours in column 3. If the status in column 1 was "In-Progress" or "Reserved" I would like the New Column to pick up the hours from column 2.

Can anyone help with the coding for this?

Thanks.

[MarcoWedel]

please don't create multiple threads for the same question:

Bringing 2 columns of numbers into a new column depending on criteria

thanks

regards

Marco