Hi Jim,

Please read

https://www.myonlinetraininghub.com/excel-forum/forum-rules-and-guides/read-this-first

Please attach your workbook.  Without your workbook it makes it more difficult to visualize and recreating your data will be prone to error.

Regards

Phil

Thanks for the response. I just uploaded my excel file 

Thanks Jim,

The workbook doesn't match up with your description of what you are trying to do.  There's nothing in Column C.  Col B contains text so can't be added to anything?

Regards

Phil

I am trying to assign a value to an excel spread sheet. Here's the example; Columns A & B need to be added in Column C (A1+B1=C1).

If the Value of C1 >0 AND <=60 then I need to Pull from another Column a Value in Column D to be Multiplied by the Value in Column I.

I need to perform this calculation for intervals of 5. Example 60,65,70. Can anyone please help?  

Hi Jim,

You can use VLOOKUP to do this.  I've modified the lookup table in Cols H:I in order that VLOOKUP will work correctly.

Your example lookup table increments in 10's not 5's so you'll need to adjust the lookup table accordingly.

see attached.

Regards

Phil

Thank you.

You're welcome.