VLOOKUP when text is than 1000 characters or more

[Nick70]

Hi,

I would like to do a VLOOKUP between range(B2:B10) and range(D2:D10).

Basically I would like to see if text in range(B2:B10) is contained in range(D2:D10).

My problem is that the text in range(B2:B10) and range(D2:D10) is often greater than 255 characters (maximum for VLOOKUP formula).

What other formula can I use?

Thanks,
Nicola

 

[Fluff]

You can try Xlookup which I think can handle longer strings.

 

[Nick70]

Yes this works fine thanks!

 

[Fluff]

You're welcome & thanks for the feedback.