0

How would I use a Vlookup with multiple tildes in the text string? It would look something like this:

SWBC ~ 7797_Dodge_Challenger ~ Video ~ New

What would the VLookup formula be?

SO Analytics
  • 1

1 Answers1

0

With a table like this where the value you want to search for (D3) has tilde characters, you can use =VLOOKUP(SUBSTITUTE(D3,"~","~~"),A:B,2,FALSE) to force excel to search for literal ~ characters:

enter image description here

The output from the vlookup formula is orange

See Working with "~" in excel for more information

Cpt.Whale
  • 10,914