Forum Discussion
Solved
vlookup formula
Is there anyone who can help me to pass this exam on Vlookup, thanks so much~
hiker7457 Change the table in the second sheet like in the picture below (highlighted in yellow). Then it shall work.
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)
hiker7457 Change the table in the second sheet like in the picture below (highlighted in yellow). Then it shall work.
Thanks so much Sir, it really helps me.
