View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
L.Chua L.Chua is offline
external usenet poster
 
Posts: 1
Default Way to average a group of results from using LOOKUP?

I have a table of scores achieved as a result of using the LOOKUP function
(typical % converted to score type of scenario). I am trying to average (say
10) resulting scores but am running into problems where I constantly receive
the #div/0 error or receive a 0. I can't see where I'm dividing by 0.

Any thoughts on how to work around this?

Thanks!