SOLVED

vlookup formula

Copper Contributor

Is there anyone who can help me to pass this exam on Vlookup, thanks so much~

4 Replies

what's the problem for this formula?

=VLOOKUP(SUMIF(学习安排表!$B$2:$B$23,A2,学习安排表!$D$2:$D$23),等级对照表!$A$2:$B$5,2,TRUE)

 

best response confirmed by hiker7457 (Copper Contributor)
Solution

@hiker7457 Change the table in the second sheet like in the picture below (highlighted in yellow). Then it shall work.

Screenshot 2020-12-23 at 06.27.15.png

Thanks so much Sir, it really helps me.

1 best response

Accepted Solutions
best response confirmed by hiker7457 (Copper Contributor)
Solution

@hiker7457 Change the table in the second sheet like in the picture below (highlighted in yellow). Then it shall work.

Screenshot 2020-12-23 at 06.27.15.png

View solution in original post