VLOOKUP使用要点

使用场景

1.表A的A-J列包含前一天Triage结果

Title	Automation Tag	Project	Status	Owner	Script Correct	Failure Type	Fix Info	Ticket	Comment
parent sign up with email	ONB0045	ONB	Failed	yanmin		Product Issue		ROW-319	家长注册未弹出添加学生
parent sign up with email, and change email	ONB0042	ONB	Failed	yanmin		Product Issue		ROW-319	家长注册未弹出添加学生
(Cypress) Parent verify sign up page and sign up successfully	ONB0041	ONB	Failed	yanmin		Product Issue		ROW-319	家长注册未弹出添加学生

2.表B中E-J列是当日待办，需要在前一天的结果的基础上继续工作

Title	Automation Tag	Project	Status	Owner	Script Correct	Failure Type	Fix Info	Ticket	Comment
parent sign up with email	ONB0045	ONB	Failed
parent sign up with email, and change email	ONB0042	ONB	Failed
(Cypress) Parent verify sign up page and sign up successfully	ONB0041	ONB	Failed

 需求

在表B中按Automation Tag搜索出表A中的结果，并复制到表B。

实现要点

=VLOOKUP(表B查找值列序数，数据表范围，列序数，匹配条件)

=VLOOKUP(B2,Yesterday,4,0)

1.表B查找值列Automation Tag的列序数为B2

2.可右击任意单元格，为表A定义一个range，命名为Yesterday 

注意：数据表范围的第一列应该始终是搜索键所在的列

3.列序数为返回值所在的列在range的第几列，此处待返回的Owner值在range第4列

4. 匹配条件FALSE代表精确匹配

注意：默认模糊匹配，很大概率会匹配到近似值，不准确