Can't seem to figure this one out...
A B C D Cust1 Cust2 Invoice1 $50 $100 Invoice2 $50 Invoice3 $100 Total $200 Cust2 Invoice4 $100 Total $100 Cust3 Invoice10 $60 Invoice13 $100 Total $160
From the above table, when I choose cust2 in D1, I want D2 to yield "$100" which is the total for customer2.
I can find cust2 from Column A using match and then maybe create vlookup array with Offset function??
Here's my failed attempt.
'=INDEX(B:B,MATCH("TOTAL",OFFSET(ADDRESS(MATCH(D1,A:A,0),1,4,1),0,0,1000,1),0),1)
Help me!
Bookmarks