inexact search
 

I have a sheets containing data with headers that I am going to manipulate
with a macro. The problem is that the headers contain spaces after the text
(though not always) and so a search when referenced to another cell (e.g.
using VLOOKUP or IF statement- not decided yet) is coming back empty.

One option is to edit the input data first using a simple macro
(Find+Replace), though I would be keen to learn of options if available.

Cheers

M

inexact search
 

Hi
have a look at the TRIM function to manipulate these entries

"Mourinho" wrote:


I have a sheets containing data with headers that I am going to manipulate
with a macro. The problem is that the headers contain spaces after the text
(though not always) and so a search when referenced to another cell (e.g.
using VLOOKUP or IF statement- not decided yet) is coming back empty.

One option is to edit the input data first using a simple macro
(Find+Replace), though I would be keen to learn of options if available.

Cheers

M