D
David Ryan
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,2245},{"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
lookup function
=IFERROR(LOOKUP(A3,{7,8,9,13,1330,1430,15,2130,2245},{"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