Information into certain tabs dependent on drop down list

[Cuffy70]

I am looking to populate the account address details on the Copy Me tab by choosing an option from column L on the SC Schedule tab.
This will in turn gather the relevant information from the Job Details tab.
I have tried numerous ways but i feel it is beyond my capabilities.

[JBeaucaire]

I'm not following the cells needed to be looked at specifically.

[Cuffy70]

H10,11,12 & 13 on the 'Copy me' tab will be populated from A7,8,9,10, B7 or C7 on the 'Job details' tab depending on what is chosen from the drop down list in L4 on the 'Sc Schedule' tab.
I have updated the attachment with the cells highlighted in Orange
Copy of New Varian Order Schedule.xls

[JBeaucaire]

If JOB ADDRESS is selected, the results will pull from A7:A10.
If ACCOUNT ADDRESS is selected, the results will pull from ??????
If COLLECTION is selected, the results will pull from ??????

[Cuffy70]

Apologies.
I hadn't saved the file correctly.
B7 & C7.
If either of these are selected it will only display 'Account Address' or 'Collection'

[JBeaucaire]

H10: =IF('SC Schedule'!$L$4="Job Address", 'Job Details'!A7, 'SC Schedule'!$L$4)

H11: =IF('SC Schedule'!$L$4="Job Address", 'Job Details'!A8, "")
(copied down)

[Cuffy70]

Brilliant!!
Thank you very much.

[Cuffy70]

Hi,
Just noticed that i missed something.
If i add tabs to create a new order i have to insert the purchase order number into K21 on the order tab (Copy me). This will correspond to the SC no. in column B of the SC Schedule.
This will then populate H10,11,12 & 13 in the same way that B9 etc are populated on the same sheet.
It is a VLook code. I have tried to input this in a few ways but somewhere i keep using too many characters.

[Cuffy70]

Hi,
Not sure if you saw my post below but i have yet again tried different ways to achieve this but keep coming up with errors

[JBeaucaire]

No idea in the blind what you're running into.

[Cuffy70]

Basically the formula worked but only on one tab. I need to to be able to create additional tabs thus raising additional purchase orders but the information provided on that tab relates to a line created on the SC Schedule.
In the same way that the Contractor information is created

[JBeaucaire]

I'm sorry, your question is not clear to me. You already seem to have this VLOOKUP idea working in B9:B13.

[Cuffy70]

Yes i do and i have tried to incorporate the same idea but it only shows what is visible in I4 of the SC Schedule and not the actual address. I have been trying to use the VLOOKUP in conjunction with the formula you provided.

[JBeaucaire]

I don't see where the Delivery Address would be listed to show in that section on row 001 of the SC Schedule?

If Job Address, then lookup 001 in column B and return the addres listed in column ?
If ?????
If ?????

[Cuffy70]

It is not. It would have to take it from the Job Details tab as per the previous formula