Vlookup and datamatching
 

Hello,

I have a problem with a dataset I import from a business system. When I
want to look úp in the system it returns #N/A. However if I activate
the cell and press enter Excel CAN perform the lookup. That is if I go
into every cell I look up the formula works fine. I cannot change the
formats of the cell in any way before I have visited the cell. Anybody
who has any idea of how to solve this problem, I would be most
grateful.


Thanks in advance

/Heine

Vlookup and datamatching
 

ToolsOptionsCalculation tabSelect Automatic

"Heine" wrote:

Hello,

I have a problem with a dataset I import from a business system. When I
want to look úp in the system it returns #N/A. However if I activate
the cell and press enter Excel CAN perform the lookup. That is if I go
into every cell I look up the formula works fine. I cannot change the
formats of the cell in any way before I have visited the cell. Anybody
who has any idea of how to solve this problem, I would be most
grateful.


Thanks in advance

/Heine

Vlookup and datamatching
 

Problem is with the data being imported; open that spreadsheet and select the
column of data being referenced in the Lookup... then

From the Task Bar; select Data €“ Text to Columns

Then simply select "Finish" on the lower right of the displayed panel

Now look at the results of your Lookup ...........anticipate #N/A results
should have disappeared.

"Teethless mama" wrote:

ToolsOptionsCalculation tabSelect Automatic

"Heine" wrote:

Hello,

I have a problem with a dataset I import from a business system. When I
want to look úp in the system it returns #N/A. However if I activate
the cell and press enter Excel CAN perform the lookup. That is if I go
into every cell I look up the formula works fine. I cannot change the
formats of the cell in any way before I have visited the cell. Anybody
who has any idea of how to solve this problem, I would be most
grateful.


Thanks in advance

/Heine

Vlookup and datamatching
 

Thanks Dave - that works just great - you have saved the my day!

/Heine
Dave Mc wrote:
Problem is with the data being imported; open that spreadsheet and select the
column of data being referenced in the Lookup... then

From the Task Bar; select Data - Text to Columns

Then simply select "Finish" on the lower right of the displayed panel

Now look at the results of your Lookup ...........anticipate #N/A results
should have disappeared.

"Teethless mama" wrote:

ToolsOptionsCalculation tabSelect Automatic

"Heine" wrote:

Hello,

I have a problem with a dataset I import from a business system. When I
want to look úp in the system it returns #N/A. However if I activate
the cell and press enter Excel CAN perform the lookup. That is if I go
into every cell I look up the formula works fine. I cannot change the
formats of the cell in any way before I have visited the cell. Anybody
who has any idea of how to solve this problem, I would be most
grateful.


Thanks in advance

/Heine