如何进行返回的查找，该查找比excel中的比赛的第一例
我正在为夏季雇用新的助教。我们拥有夏季学期的TAS的主要数据库，称为“输入”。我们在一个名为“坑”的选项卡中有一个先前TA的数据库。我正在使用Xlookup公式来查看TA的夏季课程是否与他们在坑中列出的旧课程相匹配。 TA将根据与上次相同的课程而转到不同的表格。我遇到的问题是，对于具有以上一项以上工作的TA，Xlookup只能查看该ta名称的最高排是否具有匹配的课程，当我需要检查所有这些课程时，以便TAS即使当前的课程也列在“坑”中，也没有被确定为他们以前从未教过的全新课程。这是我的公式：
=IF(XLOOKUP($B5,'The Pit'!$L:$L,'The Pit'!O:O,"Enter here")<>R5,"Job Change/Raises","Same Job")
其中b5是ta id，坑l：l也是ta id，坑o：o是路线，R5是当前的夏季课程。
有没有办法告诉它查看比赛的所有实例？还是给我一个我想使用哪一行的下拉选择？我希望继续使用Xlookup，但要对其他公式或想法开放。
I am working on hiring new teaching assistants for summer. We have our main database for the TAs for summer semester called "input". We have a database of previous TAs in a tab called "the pit." I am using an xlookup formula to see if a TA's summer course matches their old course listed in the pit. The TA will go to a different sheet based on if they have the same course as last time or not. The problem I have is that for TAs with more than one previous job, the xlookup only looks to see if the top-most row with that TA's name has a course that matches, when I need it to check all of them so that TAs are not being identified as having a brand new course that they haven't taught before, even if the current course is also listed farther down in "the pit". Here is my formula:
=IF(XLOOKUP($B5,'The Pit'!$L:$L,'The Pit'!O:O,"Enter here")<>R5,"Job Change/Raises","Same Job")
Where B5 is the TA ID, the Pit L:L is TA ID as well, the Pit O:O is course, and R5 is the current summer course.
Is there a way to tell it to look at all instances of the student ID for a match? Or give me a drop down choice of which row I'd like to use? I would prefer to keep using xlookup, but open to other formulas or ideas.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论