troubleshooting Question

excel lookup/search 2 columns and populate Column A and B with the data (Special)

Avatar of conceptdata
conceptdataFlag for Denmark asked on
Microsoft Excel
8 Comments1 Solution289 ViewsLast Modified:
Hi

I need to lookup/search 2 columns in 2 sheets and populate Column A and B with the data.

Explanation :
- Sheet : "GeneralPostingSetup"
- - Column A and B must be populated with data from :
- - - -> Sheet : Debitorgrupper_C5, Column C
- - - -> Sheet : Varegrupper_C5, Column C

Example of data
Populated Columns
A         B
AU       150
BE       150
CA       150
AU       300
BE       300
CA       300
AU       750
BE       750
CA       750

Source Coulmns :
Debitorgrupper_C5, Column C
AU
BE
CA

Varegrupper_C5, Column C
150
300
750

Is it possible. ?
Thanks
ASKER CERTIFIED SOLUTION
Glenn Ray
US Data Team Lead
Join our community to see this answer!
Unlock 1 Answer and 8 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 8 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