0

Excel experts, what am I missing here? Why is the formula evaluating to #N/A in cell C1? All cells are formatted as text

Values

Formulas

Actual value in A1: 1~3104641~A~ ~0000252415~BLUE SYCAM00001

Actual value in B1: 1~3104641~A~ ~0000252415~BLUE SYCAM00001

Justin
  • 65
  • 5

1 Answers1

1

Vlookup doesn't like the single tilde(~). You need to double it with this formula:

    =VLOOKUP(SUBSTITUTE(B1,"~","~~"),A1,1,0)
Isolated
  • 5,169
  • 1
  • 6
  • 18
  • You're awesome. Thank you for saving me the hours of deepening the forehead-shaped dent in my desk. – Justin Nov 18 '20 at 01:25