G
Guest
I have a sheet with 5 colums that has a finance number and 3 cols that have
numbers. I gave it a range res. On my main page I have it do a vlookup of
the finance number =vlookup(b2,res,3,false). Now the problem is that we have
offices that have multiple zip codes with the same finance number. What I
want to do is when the vlookup looks up the finance number, it adds all the
numbers that go with that finance number. For example if a2 and a5 have the
same finance number in the res range then it would add c2 and c5 in the cell
I put the vlookup in. Can this be done?
numbers. I gave it a range res. On my main page I have it do a vlookup of
the finance number =vlookup(b2,res,3,false). Now the problem is that we have
offices that have multiple zip codes with the same finance number. What I
want to do is when the vlookup looks up the finance number, it adds all the
numbers that go with that finance number. For example if a2 and a5 have the
same finance number in the res range then it would add c2 and c5 in the cell
I put the vlookup in. Can this be done?