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

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

Source Coulmns :how do any one know that AU =150 or BE=300 or CA=750?

Debitorgrupper_C5, Column C

AU

BE

CA

Varegrupper_C5, Column C

150

300

750

Thanks

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

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

Thanks

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 :)

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"

SEARCH Varegrupper_C5 Column C

//First ROW "150"

SET "GeneralPostingSetup"/"B4"

//Second ROW

SET "GeneralPostingSetup"/"A5"

SET "GeneralPostingSetup"/"B5"

//Third ROW

SET "GeneralPostingSetup"/"A6"

SET "GeneralPostingSetup"/"B6"

...

...

...

...

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.

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

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
Thanks