Can anyone help me figure out the easiest way to do this?

Sheet 1 Sheet 2

A B A B (Results)

1) 20 1) 70 1) 4050 1)
2) 30 2) 35 2) 6030 2)
3) 60 3) 10 3) 8010 3)
4) 50 4) 90 4) 2045 4)


Im trying to construct a lookup table using the above information as
example. This is what I want to do:

If the first two digits of Sheet 2 in Column A match any of the numbers in
range A1:A4 (Sheet 1) then I want the answer to be any word I choose €œCHARD€�
but if not in the first range then I want the formula to look at range B1:B4
(Sheet 1) and return €œMERLOT€�. Basically I want to use this guide line in
about 8 different ranges that will return a specific word for each range that
is met.