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!

Way to average a group of results from using LOOKUP?
 

It's because the values returned by the lookup function are formatted as
text. To fix, you can do a couple things:

Add a double negative (--) to the beginning of each lookup function, this
will force Excel to return the results formatted as a number (Note: Simply
doing a <Format<Cells<Number will NOT work)

=--LOOKUP(...)

You can also chage it at the source by forcing Excel to treat your lookup
range numerically. To do this:

Copy a blank cell
Select your range
<Edit<Paste Special...
Select "Values" and "Add"
Click OK

--
Regards,
Dave


"L.Chua" wrote:

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!

Way to average a group of results from using LOOKUP?
 

Thanks guru!

"David Billigmeier" wrote:

It's because the values returned by the lookup function are formatted as
text. To fix, you can do a couple things:

Add a double negative (--) to the beginning of each lookup function, this
will force Excel to return the results formatted as a number (Note: Simply
doing a <Format<Cells<Number will NOT work)

=--LOOKUP(...)

You can also chage it at the source by forcing Excel to treat your lookup
range numerically. To do this:

Copy a blank cell
Select your range
<Edit<Paste Special...
Select "Values" and "Add"
Click OK

--
Regards,
Dave


"L.Chua" wrote:

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!