Populate a column depending on the contents of other sheets.

[Edinson]

Hello All,

Could someone help me with this query please?

In the attached file there are four sheets (USA, ROW, EU and DATA)

All sheets have two columns in common (Country and Format)
The "DATA" sheet has the "Format" column the other three sheets have the "Format" column populated.

I need a macro to do the following:

For each Country in sheet USA = Country in sheet DATA then make the Format column in the DATA sheet = the Format Column in the USA sheet.
For each Country in sheet ROW = Country in sheet DATA then make the Format column in the DATA sheet = the Format Column in the ROW sheet.
For each Country in sheet EU = Country in sheet DATA then make the Format column in the DATA sheet = the Format Column in the EU sheet.

[ARGK]

Hi
Cut and paste this formula into Cell I2 on your Data sheet and copy down:

=IF(ISNA(VLOOKUP(H2,USA!A:B,2,0)),IF(ISNA(VLOOKUP(H2,EU!A:B,2,0)),VLOOKUP(H2,RoW!A:B,2,0),VLOOKUP(H2,EU!A:B,2,0)),VLOOKUP(H2,USA!A:B,2,0))

Good luck.
Tony

[:) Sixthsense :)]

In I2 Cell of Data Sheet

=IFERROR(VLOOKUP(H2,USA!A:B,2,FALSE),IFERROR(VLOOKUP(H2,EU!A:B,2,FALSE),IFERROR(VLOOKUP(H2,RoW!A:B,2,FALSE),"")))

Drag it down…

[Edinson]

Thanks ARGK and Sixthsense both replies are spot on - fantastic result!!! Thank you very much again