I have a data base that has items listed in column A. In columns b,c,d,e,f I have number values. The data is about 700 rows long.
I wrote a vlookup that can find the value in any single column but what I want to do is look up a particular item then go across and sum up the values in b,c,d,e,f. Any ideas?
Thanks
I wrote a vlookup that can find the value in any single column but what I want to do is look up a particular item then go across and sum up the values in b,c,d,e,f. Any ideas?
Thanks