Formatting in Excel price lists sent by suppliers often causes VLOOKUP errors.
Editing each of the reference cells fixes this (F2 then Enter) but with multiple lines, this may not be practicable.
Example Formula Resulting in #N/A Error
=VLOOKUP(A2,SEITALS!A:I,2,FALSE)
Example Formula Returning the Correct Result
=VLOOKUP(SUBSTITUTE(A2,CHAR(10),””),SEITALS!$A:$I,2,FALSE)
Source: https://superuser.com/questions/1685147/vlookup-wont-work-unless-text-is-retyped-manually-even-after-cleaning-and-trimm
Editing each of the reference cells fixes this (F2 then Enter) but with multiple lines, this may not be practicable.
Example Formula Resulting in #N/A Error
=VLOOKUP(A2,SEITALS!A:I,2,FALSE)
Example Formula Returning the Correct Result
=VLOOKUP(SUBSTITUTE(A2,CHAR(10),””),SEITALS!$A:$I,2,FALSE)
Source: https://superuser.com/questions/1685147/vlookup-wont-work-unless-text-is-retyped-manually-even-after-cleaning-and-trimm
VLOOKUP Returns #N/A Error Due to Formatting Issues