Linking a text to a number

Hi Coach_Callum_Robson,

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:

1. In cell G2, enter the following formula:

=VLOOKUP(C2,D:D,2,FALSE)​

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.

1. Press Enter.

Excel will now calculate the total for the day, taking into account the price per session for each client.