View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sweetetc
 
Posts: n/a
Default My formula show up in the cell instead of a resulting value

I have a look up formula
=VLOOKUP($A2,AFT_CDSCLIAB_LAC!$A:$X,9,FALSE)-VLOOKUP($A2,BEF_CDSCLIAB_LAC!$A:$X,9,FALSE)

Instead of showing the resulting value it displayes the formula
--
Thanks
ETC