Hi Dave,

VLOOKUP() cannot look to the left so use INDEX() & MATCH

In G2, (I am assuming that you have labels in Row 1), enter the forumula:

=INDEX(Sheet2!$A$2:$A$32,MATCH(B2,Sheet2!$B$2:$B$3 2,0))

Change the ranges to suit the ranges that you are using.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dave" wrote in message
...
Hi Sandy,

I appear to have got some of my things mixed up and could do with some
help
amending the =VLOOKUP formula.

My code in Sheet 1 is in Column B

My code in Sheet 2 is in Column B

My TYPE in Sheet 2 is in Column A

I need this TYPE then pasted into Column G of Sheet 1.

Thanks!
Dave

"Sandy Mann" wrote:

Do you really want a Macro?

=VLOOKUP(A1,Sheet2!A1:B23,2,0)

Will do what you want.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dave" wrote in message
...
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