Macro categorizing names

[hsingh2088]

Hi,

I am trying to develop a spreadsheet with a supply chain focus. I have approx 16K rows and 14 categories. Basically, each cell has an A, B. C. D. E, F etc (Column A). I want A = Pencils, B = Pens, C = Paper in the cell next to it in the adjacent column, B to show the name (Pen, Pencil, Paper)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column 1[/TD]
[TD]Column 2[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]=[/TD]
[TD]Pen[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]=[/TD]
[TD]Pencil[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]=[/TD]
[TD]Paper[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]=[/TD]
[TD]Etc[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]=[/TD]
[TD]Etc[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

How do I develop a Macro to do this? I recorded one cell, and can't figure out the rest, here is the current formula

ActiveCell.FormulaR1C1 = "=IF(RC[-1]=""A"", ""FABRICATED EQUIP"", ""NIL"")"
Range("I4").Select

 

[iggydarsa]

I think it is unnecessary to create a macro because you can accomplish the same thing with VLOOKUP.

Does it have to be in a macro? or do you need help with VLOOKUP?

 

[hsingh2088]

Well the issue is I need to create a table so I can overlay a PowerPivot on it. If I can accomplish that using VLOOKUP in each cell, wouldn't it take more resources?