troubleshooting Question

Displaying content from one sheet in another when there is match??

Avatar of Tom Moholland
Tom Moholland asked on
Microsoft ExcelMicrosoft Office
4 Comments1 Solution50 ViewsLast Modified:
Can anyone come up with a formula solution to populate the green colored tabs with the information from the GL Income tab in the attached document.  The commonality is the numbers in row 4 of the gl income tab, you will see when they any of the numbers in row 1's of the green tab documents the numbers from Gl income document then display. Right now I am cutting and pasting these and it take a long time and I always manage to make a mistake or two when pasting.
test.xlsx
ASKER CERTIFIED SOLUTION
Flyster

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros