Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - change size of text as a result of conditional format | Excel Discussion (Misc queries) | |||
Excel 2007 Lookup | Excel Worksheet Functions | |||
why result 77.1 * 850 shown 100000 in excel 2007? | Excel Discussion (Misc queries) | |||
Lookup for more than one result | Excel Discussion (Misc queries) | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions |