Using a lookup table to populate a column in Source Table.

[Somewhere]

Hi

Here is what I am trying to achieve:

I have a Table1 on Sheet1 in my workbook.

I am trying to get a macro setup that looks up against Table2 (located on Sheet2 in my workbook) using the STATE and TYPE columns

When the criteria matches the PRIORITY Value is copied from Table2 into the PRIORITY column in Table1

I have attached a screen shot which hopefully helps explain this..

https://www.dropbox.com/s/r3rlq54y5nj66i7/IMG_6376.PNG?dl=0

 

[mumps]

It's difficult to work with a picture. Can you upload a copy of your file?

 

[Fluff]

Any reason for a macro? This can easily be done by a formula.

 

[Somewhere]

Its a really large table so was hopeful to achieve this in VBA rather than copying down a formula in the column.

 

[Fluff]

One of the beauties about tables, is you don't need to fill the formula down. Put this in the first cell
=IFERROR(INDEX(Table2[priority],MATCH([@State]&"|"&[@Type],INDEX(Table2[State]&"|"&Table2[type],0),0)),"")
and it should fill down automatically.

 

[Somewhere]

Great thanks, I need to manipulate the data more once the look formula populates the values..so by using the formula and copy/paste values in a macro seems to have done it

 

[Fluff]

Glad you sorted it & thanks for the feedback