Excel 2007 - VLOOKUP always returns #N/A
 

I have just migrated to Excel 2007. The function VLOOKUP always returns #N/A
when it was not the case with Excel 2003.
Are there any settings I have to change in the Excel or Office options?

Thank you for your help
--
Patrick

Excel 2007 - VLOOKUP always returns #N/A
 

Post your formula and what data you use

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Patrick" wrote in message
...
I have just migrated to Excel 2007. The function VLOOKUP always returns
#N/A
when it was not the case with Excel 2003.
Are there any settings I have to change in the Excel or Office options?

Thank you for your help
--
Patrick

Excel 2007 - VLOOKUP always returns #N/A
 

I use the standard VLOOKUP formula
My objective is to get information that is in another file. I often use this
function. Since I am under Excel 2007 reply is always #N/A. Maybe some
security or advanced options need to be enabled or disabled.
--
Patrick


"Niek Otten" wrote:

Post your formula and what data you use

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Patrick" wrote in message
...
I have just migrated to Excel 2007. The function VLOOKUP always returns
#N/A
when it was not the case with Excel 2003.
Are there any settings I have to change in the Excel or Office options?

Thank you for your help
--
Patrick

Excel 2007 - VLOOKUP always returns #N/A
 

There is no standard VLOOKUP formula. The bevior depends very much on the
4th argument (FALSE or TRUE), on the data being sorted or not, the relative
column number in the 3rd argument etc.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Patrick" wrote in message
...
I use the standard VLOOKUP formula
My objective is to get information that is in another file. I often use
this
function. Since I am under Excel 2007 reply is always #N/A. Maybe some
security or advanced options need to be enabled or disabled.
--
Patrick


"Niek Otten" wrote:

Post your formula and what data you use

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Patrick" wrote in message
...
I have just migrated to Excel 2007. The function VLOOKUP always returns
#N/A
when it was not the case with Excel 2003.
Are there any settings I have to change in the Excel or Office options?

Thank you for your help
--
Patrick

Excel 2007 - VLOOKUP always returns #N/A
 

And, since you're extracting data from another file, the presence of spaces
or other nonprinting characters. This happens quite often if you import data
from other applications, web browsers, etc.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message
...
There is no standard VLOOKUP formula. The bevior depends very much on the
4th argument (FALSE or TRUE), on the data being sorted or not, the
relative column number in the 3rd argument etc.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Patrick" wrote in message
...
I use the standard VLOOKUP formula
My objective is to get information that is in another file. I often use
this
function. Since I am under Excel 2007 reply is always #N/A. Maybe some
security or advanced options need to be enabled or disabled.
--
Patrick


"Niek Otten" wrote:

Post your formula and what data you use

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Patrick" wrote in message
...
I have just migrated to Excel 2007. The function VLOOKUP always returns
#N/A
when it was not the case with Excel 2003.
Are there any settings I have to change in the Excel or Office
options?

Thank you for your help
--
Patrick