=VLOOKUP(D2,'Sheet 1 (2)'!$D$2:$D$43,1,0)
1. first choose a value as the parameter 1
2. choose the search area, but don't forget to add a $ maually (if not, the seach area will change when we copy the vlookup)
3. click the column when it displays a +
scroll down , then we will get the result.
1. first choose a value as the parameter 1
2. choose the search area, but don't forget to add a $ maually (if not, the seach area will change when we copy the vlookup)
3. click the column when it displays a +
scroll down , then we will get the result.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13975809/viewspace-2131654/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
