ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Biggie for me (https://www.excelbanter.com/excel-programming/387820-biggie-me.html)

Khanjohn

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?


All times are GMT +1. The time now is 11:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com