Hi Guys!

I need help with a macro.

I have a value in cell A1 of Sheet 1 e.g. A12345

I have a list in Sheet 2 with a list of values e.g. A12344, A12345, A12346
etc. with an associated value e.g. HOME, AWAY, INDOOR

I want to be able to take the value from Sheet 1, find it in Sheet 2, and
paste the associated value from Sheet 2 into Sheet 1, cell B1.

I then have a different value in cell A2 of Sheet 1 and I need to look this
up etc.

Can someone please help me?

Thanks!
Dave