Avatar of conceptdata
conceptdata
Flag for Denmark asked on

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

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
Microsoft Excel

Avatar of undefined
Last Comment
Glenn Ray

8/22/2022 - Mon
Naresh Patel

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

Thanks
Naresh Patel

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
conceptdata

ASKER
Here a Sample file
Mappe2.xlsx
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Naresh Patel

ok thanks give me 5 min.
Naresh Patel

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
conceptdata

ASKER
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 :)
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Naresh Patel

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
ASKER CERTIFIED SOLUTION
Glenn Ray

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question