Need A Solution To A Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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
 
To give you an exact formula, if you're at all familiar with Excel cell and
range addresses, we'll need to know the address of your code on sheet1 and
the addresses of your code/type range on sheet2 and the address of the cell
in column G on sheet1 where you want the result put.

Tyro
 
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$32,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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Back
Top