We help IT Professionals succeed at work.

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

conceptdata
conceptdata asked
on
285 Views
Last Modified: 2014-05-08
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
Comment
Watch Question

Naresh PatelFinancial Adviser

Commented:
will you post sample file? then it will be easy ..

Thanks
Naresh PatelFinancial Adviser

Commented:
Source Coulmns :
 Debitorgrupper_C5, Column C
 AU
 BE
 CA

 Varegrupper_C5, Column C
 150
 300
 750
how do any one know that AU =150 or BE=300 or CA=750?


Thanks

Author

Commented:
Here a Sample file
Mappe2.xlsx
Naresh PatelFinancial Adviser

Commented:
ok thanks give me 5 min.
Naresh PatelFinancial Adviser

Commented:
See attached I had created one helper sheet called "Source". so if you change any thing in "GenerakPostingSetup" it will populate its respective value. is this you are looking for?


Thanks
Mappe2.xlsx

Author

Commented:
No, not exactly.

If you see in the the file I attached, see "GeneralPostingSetup", I hav made samo example data......

I try to explain :

SEARCH Debitorgrupper_C5 Column C
  //First ROW "AU"
  SET "GeneralPostingSetup"/"A4" = "AU"
 
  SEARCH Varegrupper_C5 Column C
    //First ROW "150"  
    SET "GeneralPostingSetup"/"B4" = "150"
    //Second ROW
    SET "GeneralPostingSetup"/"A5" = "AU"
    SET "GeneralPostingSetup"/"B5" = "300"
    //Third ROW
    SET "GeneralPostingSetup"/"A6" = "AU"
    SET "GeneralPostingSetup"/"B6" = "750"
    ...
    ...
    ...
    ...
  END
END

Does it make sense :)
Naresh PatelFinancial Adviser

Commented:
So you need macro or VBA for this question?  As I don't understand you exactly what you are trying to do...sorry my bad ...if you are looking for VBA then I am not the right person......I suggest press --- Request Attention Button.Request ButtonThanks
Excel VBA Developer
CERTIFIED EXPERT
Top Expert 2014
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.