首先，我是电子表格的完整新手，所以请像我五岁那样向我解释事情。其次，我已经在整个Internet上搜索了此信息，但是唯一的帮助似乎与基于一个单元格的值（而不是两个）输入数据有关。
我是一名语言老师，我正在使用跟踪器来保留我教授的所有课程的记录。有三个重要值：
- 课程（初学者，基础，中级，上级或高级）。我正在从C列中输入此信息。
- 课程编号（1-20）。每个课程都包含20堂课。因此，例如，一旦学生在初学者课程中完成所有20堂课，他们就会进入基础课程。我正在从D栏中输入此信息
- 。课程标题。因此，例如，初学者第1课称为“英语简介”，中级课15称为“打电话”。我正在进入E列E中输入此信息。
当我预订新课时，我目前必须手动输入所有这些信息。但是我想加快该过程的速度，以便我只需要在C列中输入课程名称以及D列中的课程编号，第三个单元格将在E列中自动更新Exther标题。
目前，此跟踪器是一张纸。所有级别，课程编号和课程标题的表都在另一个纸上。
如果有人可以帮助我实现这一目标，我会非常感谢！
First of all, I am a complete novice at spreadsheets, so please explain things to me like I'm five years old. Secondly, I've already searched this throughout the internet but the only help seems to be related to entering data based on the value of one cell, not two.
I'm a language teacher and I'm using a tracker to keep a record of all the lessons that I teach. There are three important values:
- The course (Beginner, Elementary, Intermediate, Upper-Intermediate or Advanced). I'm entering this information in column C.
- The lesson number (1-20). Each course contains 20 lessons. So, for example, once students complete all 20 lessons in the Beginner course, they move on to the Elementary course. I'm entering this information in column D.
- The lesson title. So for example, Beginner lesson 1 is called 'Introduction to English', and Intermediate lesson 15 is called 'Making phone calls'. I'm entering this information in column E.
When I'm booked for a new lesson, I currently have to manually enter all this information. But I want to speed up the process so that I just have to enter the course name in column C and the lesson number in column D, and the third cell will automatically update in column E with the lesson title.
At the moment this tracker is one sheet. A table of all the levels, lesson numbers and lesson titles is on another sheet.
If anyone could help me accomplish this, I'd very much appreciate it!
发布评论
评论（2）
您可以使用
vlookup加入c＆amp; d的位置，然后在拥有该表格的另一张纸中查找（假设它在sheet1！a：cwhereC = Sheet1！a，d = Sheet1！b和e = Sheet1！C），然后您只在第2行中使用它：更新：
you can use
VLOOKUPwhere you join C&D and look that up in your other sheet where you have that table (let's say it's inSheet1!A:CwhereC=Sheet1!A,D=Sheet1!BandE=Sheet1!C) then you just use this in row 2:update:
@player0最终用这个非常聪明的公式帮助了我。非常感谢！
= index（ifna（vlookup（e2：e，'更新课程'！a2：j，match（d2：d，'更新课程'！a1：j1，）），）））））））））））
@player0 helped me out with the sheet in the end with this very clever formula. Thanks so much!
=INDEX(IFNA(VLOOKUP(E2:E, 'UPDATED Lessons'!A2:J, MATCH(D2:D, 'UPDATED Lessons'!A1:J1, ), )))