data from one column to produce data for next 3 columns

sasoderl

Board Regular
Joined
Feb 17, 2004
Messages
82
:rolleyes:

I am trying to write a macro OR something that will allow me to take the data entries in one column and produce the data that belongs in the next three columns.

The idea is that I have one column of numbers that range from 36 to 103. Each number is a "code" that has information that I want to appear in the spreadsheet but don't want to type it all up every time. With each of these numbers, I need to insert into the next 3 columns a two-letter code, a sentence, and a price. The info that belongs to the "code number" will never change. I'd like to automate this. How???
 

junebug

Board Regular
Joined
Apr 4, 2003
Messages
110
Try this for the heck of it. Assuming your numbers from 36-100 are in column A, then in column B paste this formula:
=vlookup(offset($A$1:$A$100,0,0),DATA,2,FALSE)
in column C paste this formula:
=vlookup(offset($A$1:$A$100,0,0),DATA,3,FALSE)
in column D paste this formula:
=vlookup(offset($A$1:$A$100,0,0),DATA,4,FALSE)
Copy these formulas down the rows. You may have to adjust the row reference $A$1:$A$100 depending on how many rows of numbers you have in column A. Make the adjustment before you copy the formulas.
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,172,010
Messages
5,878,711
Members
433,366
Latest member
kaaryy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top