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.
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.