Formula - Finding matching data from different worksheets, returning data from 3rd colum

[Rach1509]

hello, please can you help, as I am going round in circles here,

I have an excel workbook that has lots of different work sheets (each one is a different country – its list of products sold in that country – they all have the same common data of a SKU) - I need to add data to an image column and want to put it in once, and the formula put this on all the other sheets

I am trying to find common data from the “MAIN” English sheet (ie product SKU),in another country sheet and then if this matches, return data from another column in the English sheet to a different column on the Irish Sheet,

For Example

On the English Sheet

Q2:Q2073 contain a list of SKU
AM2:AM2073 contain photo URLS (I will put all the data in as I have to link each one, a couple are in for example)

On Irish Sheet
Q2:Q2068 contain a list of SKU
AL2:AL2068 is blank

If a SKU match is found on the two sheets, I want to return the information from English AM column onto Irish AL Column

(If I can get this bit right I can then do this on all the countries using English as the main data and adjust it for each sheet may have up to 5 adjacent columns for URL
)

Thanks

[JohnTopley]

In AL2

=IFERROR(INDEX('Ebay UK'!$AM$2:$AM$3000,MATCH(Ireland!$Q2,'Ebay UK'!$Q$2:$Q$3000,0)),"")

Copy down

[Rach1509]

Excllent, thank-you will do that now,

[JohnTopley]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[Rach1509]

Sorry, please can I ask again - how do I change the link when changing the worksheets, ie instead of Ireland it is now USA / Germany etc, (still rreferencing the original UK), as it is throwing errors, so I don't think I am doing it right by simply changing Ireland to USA