Thread: VLOOKUP error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Alfredo Martinez Alfredo Martinez is offline
external usenet poster
 
Posts: 5
Default VLOOKUP error

Hello guys:

This formula

=IF(C8+D8+E8=0,"",ROUND(VLOOKUP(AJ8,'Monthly Sales'!A$1:CN$6000,AK8),2))

used to work with all the previous versions. I switched to Excel 2007 and
now I am getting the #VALUE! result.

Can you help?

Many thanks in advance

--
Alfredo Martinez