Advice on comparing data sets

[spgprivate]

Hi,

Can anyone advise on how I can compare data on 1 sheet with data compared on another. Example attached.

I want to be able to show that whenever the UK is shown (can appear multiple times) on this sheet it checks on sheet2 and enter the corresponding band value in this case for the UK (show in cells B6, B8) will show band A

SHEET1
Ref Country Band
1 UK
2 Germany
3 UK
4 France
5 Italy


SHEET2
Country Band
UK A
GERMANY B
ITALY B
FRANCE D
SWEDEN D
DENMARK E


As always thanks for your help.

Simon

[swatsp0p]

Use the VLOOKUP function as such:

=VLOOKUP(B6,Sheet2!$B$6:$C$11,2,0)

copied down as needed

HTH