Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default Biggie for me

Ok here goes;

I have a formula that finds info in a range further in the workbook ie it
lpooks up a column at aa3:AF100 and returns result bck to the appropiate
column in B 3:B10. Now here is problem I have another area that can add to
the number in B3:B10. I made the first info go to cells in K3:K10, kleft a
column blank for the new data and then sumed them in M3:M10. Here is the
problem, the data to add doesnt add to each on in this maybe only be one of
the rows it will add but if it doesnt match then i get a N/A andthe original
numbers can not be seen. how do i make ti (If it matched one of the things in
M3:M10 add the numbe to the row ie)

Banana 10 0 10
Orange 10 0 10
Apple 10 0 10
onion 10 0 10
and should be

Banana 10 0 10 But get N/A
Orange 10 1 11
Apple 10 0 10 but get N/A
onion 10 0 10 but get N/A

How do i Get ti to leave blank or put a zero there?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"