Formula to add values from different columns that don't align

**dilipandey** · 05-16-2013, 09:54 AM

Hi elizo,

welcome to the forum.
Yes, you can use some lookup formula here... and would be better if you could upload a sample workbook along with your expected output. thanks.

Regards,
DILIPandey
<click on below * if this helps>

**elizo** · 05-16-2013, 10:59 AM

Here is a sample of the excel worksheet.

I am hoping to generate a total revenue sum by looking up the matching company names in Q1, Q2, and Q3.
The company names are represented by letter values and are misaligned. Hope this helps!

And thanks so much for your replies!