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.
Hellow saligatvis. Welcome to the forum.
If I understand correctly I don't believe VLOOKUP is the function of choice here.
With the color 'red' typed in cell M1 try this.Formula:
Please Login or Register to view this content.
It returns 62 at my end.
Does this help?
Dave
Having some issues can you, maybe you know where is the problem ?
Please check the attached to see if formula does what you want.
Additionally here's a shorter formula (included in attachment). Color 'red' in N1Formula:Please Login or Register to view this content.
Works great, thank you for your help
You are welcome. Glad to help.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks