Forum Discussion
Leigh_Barker
Nov 23, 2021Copper Contributor
Vlookup -
Hello, I cannot figure out why VLOOKUP will not return the data. I tried changing format to text, number, special, etc. It works for some and not others ?? LB
OliverScheurich
Nov 23, 2021Gold Contributor
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)
In sheet2 in cell A1 the entry was "0001A " with 4 spaces after the value. As the formula looks for an exact match, #NA was returned.
Leigh_Barker
Nov 23, 2021Copper Contributor