Help Excel Macro?: Assign values depending on list - Sizes and prices

**lola12** · 05-04-2013, 04:34 PM

Hi Excelforum members!

I have a question... the answer might be a macro or maybe there is an easier solution...

I have a table with a lot of columns, among those are two columns that are related...prices and sizes: depending on the size of the artwork (e.g-. 24x36) price will be something.

These prices, are kept on another list, and they go by proportions...

To summarize:

I have two tables:

A. The one with names, and sizes filled out, and an empty prices column
B. One table with different proportions and their prices (see attached) Table example.xlsx

How could I make excel fill out my prices column correctly, taking the prices from my table b? (if easier, I could copy this content into sheet2 of table A)

Harder version:

There's other data connected to those sizes that I would like to fill in too... like width and weight, but I feel like this will be way too complicated.

Can anybody help me with this? or show me how to do it?

Thanks, I really appreciate it!!

Lola

Table example.xlsx

**TMS** · 05-04-2013, 05:08 PM

Maybe:

=VLOOKUP(Table1[[#This Row],[Size]],'Table B'!B:C,2,FALSE)

Regards, TMS

**JBeaucaire** · 05-04-2013, 05:10 PM

Since ALL your sizes in Table B are unique, there are no duplicates, a simple VLOOKUP will do the work. Put this formula in C2:

=VLOOKUP([@Size], 'Table B'!B:C, 2, 0)

If you expand your table B to include the width and weight information, too, another VLOOKUP can be used to bring that data over, too.