conceptdata

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

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

ASKER

Here a Sample file

Mappe2.xlsx

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

Thanks

Mappe2.xlsx

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

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

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Thanks