If I understood your answer good, then you can use a VLOOKUP formula.
VLOOKUP stands for vertical lookup, and it allows you to look up a value in one column and return a corresponding value from another column. In this case, you would look up the client's name in column C and return the price per session from column D.
To do this, follow these steps:
In cell G2, enter the following formula:
This formula tells Excel to look up the value in cell C2 (the client's name) in the range D:D (the price per session column). If Excel finds a match, it will return the corresponding value from the second column (the price per session). If Excel does not find a match, it will return the value #N/A.
Excel will now calculate the total for the day, taking into account the price per session for each client.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item.
If the post was useful in other ways, please consider giving it Like.