=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博客 ” ，链接：http://blog.itpub.net/13975809/viewspace-2131654/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/13975809/viewspace-2131654/
977
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
