vlookup不使用相同的值

发布于 2025-01-26 01:19:32 字数 1329 浏览 1 评论 0原文

没有线断裂或空格等。

<divclass='related-search'><divclass='heading-new'><divclass='heading-new__title'>SeeRelatedSearches</div></div><divclass='related-search__list'><ahref='https://savilerowco.com/shirts/mens-white-shirts'>WhiteShirts</a><ahref='https://savilerowco.com/shirts/double-cuff-shirts'>DoubleCuffShirts</a><ahref='https://savilerowco.com/shirts/classic-fit'>ClassicFitShirts</a><ahref='https://savilerowco.com/shirts/formal-shirts'>FormalShirts</a></div></div>

嗨，我有一个粘贴的一些创建的代码块的列，

<divclass='related-search'><divclass='heading-new'><divclass='heading-new__title'>SeeRelatedSearches</div></div><divclass='related-search__list'><ahref='https://savilerowco.com/shirts/mens-white-shirts'>WhiteShirts</a><ahref='https://savilerowco.com/shirts/double-cuff-shirts'>DoubleCuffShirts</a><ahref='https://savilerowco.com/shirts/classic-fit'>ClassicFitShirts</a><ahref='https://savilerowco.com/shirts/formal-shirts'>FormalShirts</a></div></div>

rsb_1

当使用vlookup返回相关代码块的块号时，它给我带来了#Value错误。

=VLOOKUP(N2,'RSB NAME HELP'!A:D,4,0)

原文

Hi I have a column of some created code blocks pasted with no line breaks or spaces etc.

<divclass='related-search'><divclass='heading-new'><divclass='heading-new__title'>SeeRelatedSearches</div></div><divclass='related-search__list'><ahref='https://savilerowco.com/shirts/mens-white-shirts'>WhiteShirts</a><ahref='https://savilerowco.com/shirts/double-cuff-shirts'>DoubleCuffShirts</a><ahref='https://savilerowco.com/shirts/classic-fit'>ClassicFitShirts</a><ahref='https://savilerowco.com/shirts/formal-shirts'>FormalShirts</a></div></div>

I've created another column in a second sheet using each unique value of this first column and assigning it a number.

<divclass='related-search'><divclass='heading-new'><divclass='heading-new__title'>SeeRelatedSearches</div></div><divclass='related-search__list'><ahref='https://savilerowco.com/shirts/mens-white-shirts'>WhiteShirts</a><ahref='https://savilerowco.com/shirts/double-cuff-shirts'>DoubleCuffShirts</a><ahref='https://savilerowco.com/shirts/classic-fit'>ClassicFitShirts</a><ahref='https://savilerowco.com/shirts/formal-shirts'>FormalShirts</a></div></div>