Advice on comparing data sets

[spgprivate]

Hi,

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

I want to be able to show that whenever the UK is shown (can appea
multiple times) on this sheet it checks on sheet2 and enter th
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.

Simo

+-------------------------------------------------------------------
|Filename: Excelquestion.zip
|Download: http://www.excelforum.com/attachment.php?postid=5006
+-------------------------------------------------------------------

 

[swatsp0p]

Use the VLOOKUP function as such:

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

copied down as needed

HT