[已解决]用lookup格式后格式怎么设置为文本

zymnolazy · 发表于 2014-6-13 15:02

本帖最后由 zymnolazy 于 2014-6-13 18:35 编辑

请教各位，这个B列用了公式之后，怎么设置格式为文本，如附件，这个本来是为了实现填写了F列之后，B列能自动填写对应的内容。

最佳答案

zyouong

2014-6-13 16:29

="'"&LOOKUP(F2,{"胶原水凝焕采乳液","胶原水凝面膜","胶原水凝修护眼膜","胶原水凝醒肤喷雾"},{6953309400078,6953309400085,6953309400092,6953309400108})

baksy · 发表于 2014-6-13 15:05

公式最后合并一个空格
=LOOKUP(F2,{"胶原水凝焕采乳液","胶原水凝面膜","胶原水凝修护眼膜","胶原水凝醒肤喷雾"},{6953309400078,6953309400085,6953309400092,6953309400108})&""

as0810114 · 发表于 2014-6-13 15:07

=TEXT(LOOKUP(F2,{"胶原水凝焕采乳液","胶原水凝面膜","胶原水凝修护眼膜","胶原水凝醒肤喷雾"},{6953309400078,6953309400085,6953309400092,6953309400108}),"0")

tgydslr · 发表于 2014-6-13 15:20

=TEXT(LOOKUP(F2,{"胶原水凝焕采乳液","胶原水凝面膜","胶原水凝修护眼膜","胶原水凝醒肤喷雾"},{6953309400078,6953309400085,6953309400092,6953309400108}),"0")

复制代码

tgydslr · 发表于 2014-6-13 15:22

其实也没必要非用文本，自定义格式数值也行啊

zyouong · 发表于 2014-6-13 16:29

="'"&LOOKUP(F2,{"胶原水凝焕采乳液","胶原水凝面膜","胶原水凝修护眼膜","胶原水凝醒肤喷雾"},{6953309400078,6953309400085,6953309400092,6953309400108})

zymnolazy · 发表于 2014-6-13 18:36

as0810114 发表于 2014-6-13 15:07
=TEXT(LOOKUP(F2,{"胶原水凝焕采乳液","胶原水凝面膜","胶原水凝修护眼膜","胶原水凝醒肤喷雾"},{695330940 ...

可以用，赞一个

zymnolazy · 发表于 2014-6-13 18:37

tgydslr 发表于 2014-6-13 15:20

谢谢，问题解决了[em23]

zymnolazy · 发表于 2014-6-13 18:38

baksy 发表于 2014-6-13 15:05
公式最后合并一个空格
=LOOKUP(F2,{"胶原水凝焕采乳液","胶原水凝面膜","胶原水凝修护眼膜","胶原水凝醒肤 ...

谢谢，这个方法可以用[em01]

		自动登录	找回密码
密码			注册