Dear all,

apologies for the basic question. I can’t seem to work out the following. Any help would be great appreciated.

In my illustration above I have marked in Red what I would like to achieve. I’m not sure how to go about writing the formula to achieve this.

I’ve described in words below what I’m trying to make.

e.g.

I would like to populate the “Server Cost” row with cost data from the “Cost” column and row IF the “Item” Column & row contains “Server”

Let me know if this is unclear or if anyone has advice.

regards,

Sean.