I'm am trying to put together a cost analysis of a project and need some IF statement help. I have a dropdown list in H5 that has a couple of different supply options. In H6, I would like it to fill in the cost associated with that supply item if that one is chosen. I am not a formula guru but I'm assuming there's a way to do this?

Thanks