Sum Result of lookup in excel 2007
 

Hi using excel 2007 looking up values and need to sum the results

lookup function
=IFERROR(LOOKUP(A3,{7,8,9,13,1330,1430,15,2130,224 5},{"8","8","6","8","9","8","8","8","8"}),"0").
this returns great results and what I need. If the value is not found returns
0 and not #N/A if the "iferror" part is not used.

The results are in another column. When I sum the results I get 0.00
changing the format of the cell has no effect.

I hope someone can help as this has been driving me crazy and i know it will
be very simple. help please

Sum Result of lookup in excel 2007
 

Did you try clearing all existing formats and re-formatting it ..
--
If this post helps click Yes
---------------
Jacob Skaria


"David Ryan" wrote:

Hi using excel 2007 looking up values and need to sum the results

lookup function
=IFERROR(LOOKUP(A3,{7,8,9,13,1330,1430,15,2130,224 5},{"8","8","6","8","9","8","8","8","8"}),"0").
this returns great results and what I need. If the value is not found returns
0 and not #N/A if the "iferror" part is not used.

The results are in another column. When I sum the results I get 0.00
changing the format of the cell has no effect.

I hope someone can help as this has been driving me crazy and i know it will
be very simple. help please

Sum Result of lookup in excel 2007
 

David Ryan;291490 Wrote:
Hi using excel 2007 looking up values and need to sum the results

lookup function
=IFERROR(LOOKUP(A3,{7,8,9,13,1330,1430,15,2130,224 5},{"8","8","6","8","9","8","8","8","8"}),"0").
this returns great results and what I need. If the value is not found
returns
0 and not #N/A if the "iferror" part is not used.

The results are in another column. When I sum the results I get 0.00
changing the format of the cell has no effect.

I hope someone can help as this has been driving me crazy and i know it
will
be very simple. help please
Hi,
maybe removing the quotes would help.


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=81445

Sum Result of lookup in excel 2007
 

yes i have and no effect

"Jacob Skaria" wrote:

Did you try clearing all existing formats and re-formatting it ..
--
If this post helps click Yes
---------------
Jacob Skaria


"David Ryan" wrote:

Hi using excel 2007 looking up values and need to sum the results

lookup function
=IFERROR(LOOKUP(A3,{7,8,9,13,1330,1430,15,2130,224 5},{"8","8","6","8","9","8","8","8","8"}),"0").
this returns great results and what I need. If the value is not found returns
0 and not #N/A if the "iferror" part is not used.

The results are in another column. When I sum the results I get 0.00
changing the format of the cell has no effect.

I hope someone can help as this has been driving me crazy and i know it will
be very simple. help please

Sum Result of lookup in excel 2007
 

Replace the double quotes from your formula and try...........

=LOOKUP(A5,{7,8,9,13,1330,1430,15,2130,2245},{8,8, 6,8,9,8,8,8,8})
--
If this post helps click Yes
---------------
Jacob Skaria


"David Ryan" wrote:

yes i have and no effect

"Jacob Skaria" wrote:

Did you try clearing all existing formats and re-formatting it ..
--
If this post helps click Yes
---------------
Jacob Skaria


"David Ryan" wrote:

Hi using excel 2007 looking up values and need to sum the results

lookup function
=IFERROR(LOOKUP(A3,{7,8,9,13,1330,1430,15,2130,224 5},{"8","8","6","8","9","8","8","8","8"}),"0").
this returns great results and what I need. If the value is not found returns
0 and not #N/A if the "iferror" part is not used.

The results are in another column. When I sum the results I get 0.00
changing the format of the cell has no effect.

I hope someone can help as this has been driving me crazy and i know it will
be very simple. help please

Sum Result of lookup in excel 2007
 

Hi Jacob I Knew it would be simple, worked a treat thanks!!!!

"Jacob Skaria" wrote:

Replace the double quotes from your formula and try...........

=LOOKUP(A5,{7,8,9,13,1330,1430,15,2130,2245},{8,8, 6,8,9,8,8,8,8})
--
If this post helps click Yes
---------------
Jacob Skaria


"David Ryan" wrote:

yes i have and no effect

"Jacob Skaria" wrote:

Did you try clearing all existing formats and re-formatting it ..
--
If this post helps click Yes
---------------
Jacob Skaria


"David Ryan" wrote:

Hi using excel 2007 looking up values and need to sum the results

lookup function
=IFERROR(LOOKUP(A3,{7,8,9,13,1330,1430,15,2130,224 5},{"8","8","6","8","9","8","8","8","8"}),"0").
this returns great results and what I need. If the value is not found returns
0 and not #N/A if the "iferror" part is not used.

The results are in another column. When I sum the results I get 0.00
changing the format of the cell has no effect.

I hope someone can help as this has been driving me crazy and i know it will
be very simple. help please