Forum Discussion
Amateur Excel, please help!
Hey there- I'm an amateur excel user who needs some major help! I'm trying to pull out data from an aging report. Some names are exactly the same. So what I am trying to do is pull out data from...
In C17
=SUMPRODUCT(
(LEFT(lastName)>=LEFT($B17) )*
(LEFT(lastName)<=RIGHT($B17) )*
INDEX(data, 0, MATCH(C$16, headers, 0) ) )and drag to the right and down