Populate Cell of A sheet using the value of a drop list of another sheet

Hi, i will try to explain as clear as i can

Example, i have 2 sheets called [SheetCompanyA, SheetCompanyB] and a 3rd sheet called [SheetSelection]

on the 2 first sheets i have 2 records,

A1=1 A2=2,
B1=ClientA, B2=ClientB,
C1=1000, C2=2000
D1= null, D2= null

(lets say both sheets have the same values in the same cells)

and on the third i have 2 records
A1=1, A2=2,
B1=ClientA, B2=ClientB,
C1=2000, C2=3000
D = Is a Drop List containing the names CompanyA, CompanyB

Now what i need to do is,

when i select a value on the drop list depending on what it is (CompanyA or CompanyB)
it then would see that the corresponding cell on A:x value is and populate the corresponding cell on the corresponding sheet.

A bit of pseudo code just to understand it better, an example of what i want to do if i selected a value from the drop list
on the first line of the SheetSelection Sheet.

IF in [SheetSelection:D1] = CompanyA then populate with value of [SheetSelection:C1] on to [SheetCompanyA:D1]

in this example, its the first row and takes the value to the fist row of the other sheet
but that wont be always the case, that's why i need it to compare the "ID" of the client
which is on column A so it knows where to place the value.

so if i was to fill the droplist with the value CompanyA on the 2nd row it would check the [SheetSelection:A2] value and place the
[SheetSelection:C2] value in the [SheetCompanyA:D2] because of the [SheetSelection:A2] = [SheetCompanyA:A2] rule.

God i hope this is understandable

I thank you for your time in advance.

ok here is what i made but it doesn't do anything TEST.xlsx

I am not sure if I uderstand your requirements, but I tried to create a simple table.

I used the formula if, and then use filter and then show only the the data you need.

Please look at this and tell me if you can use this.

Thanks.

Or you can use macro...

Insert data, click on Update buton and see the result.

I will be available again on Monday.

Good morning,

thank you so much for your time and quick response, the second method is the one i am going to use.

i will implement it to the main xls and see how it goes.

I will give you an update.

Thank you again.

Hi, no problem..just try and let me know if it works.