hi,
I need help with vlook up formula, i have an active invoices that fills up every month with extra four vertical lines, and i need to find a match in all second vertical lines and calculate total amount from fourth vertical lines that mathes color, in attachment i have marked yellow color those cells. that i need to calculate.
Bookmarks