I am trying to cross reference all occurrences of two sets of values.

This is what I need.
Sheet 1
a b c d e
1 No. Hard Soft Hot Cold
2 10 x x
3 20 x x
4 30 x x x x


This is where the data lives
Sheet 2
a b c d e
1 No. Type
2 30 Hard
3 30 Soft
4 30 Hot
5 40 Soft
6 50 Soft
7 50 Cold


What is my best way to accommodate a lookup?
index? Offset?