I would like to learn what formula I can use to make my timesheet more efficient.

  1. How to assign a membership number to a name vice versa? I need to add lesson hours to each membership daily and typing the membership numbers, and the same each time take a lot of time.

Is there a way where I can link the members' numbers and the members' names together?

enter image description here

  1. How to assign a price to a text? I have different type of lessons, would like to be able to type in the type of lesson and the price can automaticly appear. P=$675 ; SP=$350 enter image description here

Thanks for your time!

  • Welcome to Web Applications! It is preferred if you can post separate questions instead of combining your questions into one. That way, it helps the people answering your question and also others hunting for at least one of your questions. Thanks!
    – Glorfindel
    Commented Nov 30, 2021 at 17:20
  • Consider sharing a publicly editable sample spreadsheet with realistic-looking data. Commented Nov 30, 2021 at 17:40

1 Answer 1


The concept you describe is usually implemented by creating one or more lookup tables in a separate tab. You can then use vlookup() to find names by membership numbers, membership numbers by names, and prices by lesson types. See VLOOKUP Function in Google Sheets.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.