On 15 Jan., 15:17, thread wrote:
Hi
i'm doing alot of vlookup work and very common to facea problem in
linking becaouse of additional space or blank line
does anyone have an idea how can it be overcomed?

Hi,

there is a function called trim. This enables you to take out all the
spaces at the beginning of the cell. Maybe that one helps