Link to home
Start Free TrialLog in
Avatar of conceptdata
conceptdataFlag 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
Avatar of Naresh Patel
Naresh Patel
Flag of India image

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

Thanks
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
Avatar of conceptdata

ASKER

Here a Sample file
Mappe2.xlsx
ok thanks give me 5 min.
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
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 :)
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.User generated imageThanks
ASKER CERTIFIED SOLUTION
Avatar of Glenn Ray
Glenn Ray
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial