AUTOFIILL DATA WITH TOTALS

jonnykats

New Member
Joined
Oct 11, 2006
Messages
21
ok, i have one sheet that consist of names on a1:a9 then a list of job codes on b1:b9.. now i have this other seperate sheet that tells me what dept number is associated with a specific jod code. i want to import the second sheet into the first and have the dept code next to the appropriate jod code. did i make sence?
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Crow_23

Board Regular
Joined
Feb 17, 2005
Messages
183
Sounds like you need a vlookup. Should look something like this

Code:
=VLOOKUP(B1,Sheet2!A1:B10,2,0)

B1 is where you have the job codes at b1:b9

Sheet2! is the sheet with the dept code

A1:B10 is the array within sheet 2 that u want to use as reference

The 2 changes the output of the vlookup based upon how many columns over u want (probably doesnt make sense but mess around with this # and you'll get it)

Post back if it works or not

Ed
 

Forum statistics

Threads
1,141,920
Messages
5,709,349
Members
421,631
Latest member
JDamery

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