我可以使用 vlookup 查找单元格中的某个单词吗？
我想做的是。
=VLOOKUP(C7,MODEL!A$4:B$9975,2,FALSE)
对于 Cell C7--- 夹克蓝色男式
我想要它做的是使用男式的符号
所以我的原始表列出了所有产品...这将转到另一个列表，我想要制作夹克蓝色男式---- ---- |夹克蓝色| ♂ |
那么 Vlookup 是否可以识别（男士）并使用该列表自动填充另一个单元格？
我尝试了 true，它给了我一个 NA#
谢谢...这是一个大型谜题的最后一步
新问题
每张纸上只能有一个 Vlookup 命令吗？
另外，当前的 =VLOOKUP(B397,Sheet2!C3:D5,2) 返回一个 ♂，但该单元格中的特定单词是 Women's
，所以我想我需要弄清楚它将如何区分 Women's和男士。我尝试了很多公式，但公式中出现 NA# 或错误。
谁能回答这个问题，还是我真的被困住了，必须将 ♂ 、 ♀ 和 Ω 添加到所有 10k 条目中？
What I am trying to do is.
=VLOOKUP(C7,MODEL!A$4:B$9975,2,FALSE)
For Cell C7--- Jacket Blue Men's
What I want it to do is use a Symbol for Men's
So my original sheet has the products all listed...this goes to another list and I want to make Jacket Blue Men's-------- | Jacket Blue | ♂ |
So Does Vlookup recognise (Men's) and will use the list to autofill another cell?
I tried true and it gave me a NA#
Thanks...this is the last step in a MASSIVE puzzle
NEW QUESTION
Can I only have one Vlookup command per sheet?
Also the current =VLOOKUP(B397,Sheet2!C3:D5,2) IS returning a ♂ but the specific word in that cell is Women's
So I guess I need to figure out how it will differentuate between women's and Men's. I have tried many formulas, and I get NA# or errors in the formulas.
Can anyone answer this or am I really stuck and have to add ♂ and ♀ and Ω to all 10k entries?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果您希望“Men's”始终与“♂”匹配，请尝试使用 SUBSTITUTE，它将用该符号替换查找值中“Men's”的任何实例，即
=VLOOKUP(SUBSTITUTE(C7,"Men's"," ♂"),MODEL!A$4:B$9975,2,FALSE)...或者您需要它是 | ♂ |...我不太清楚....但是原理是一样的...
=VLOOKUP(SUBSTITUTE(C7,"Men's","| ♂ |"),MODEL!A$4 :B$9975,2,FALSE)If you want "Men's" to always match with "♂" then try using SUBSTITUTE which will replace any instance of "Men's" in the lookup value with that symbol, i.e.
=VLOOKUP(SUBSTITUTE(C7,"Men's","♂"),MODEL!A$4:B$9975,2,FALSE)...or do you need it to be | ♂ |....I'm not clear....but the principle is the same....
=VLOOKUP(SUBSTITUTE(C7,"Men's","| ♂ |"),MODEL!A$4:B$9975,2,FALSE)