View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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