Need simple formula to get data from sheet1 to sheet2

[jmcole]

I have attached a small version of what I am working on. I need help with this formula.

The dept numbers in column A on sheet2 are not always in the same order. In the B column of sheet1, I need it to find the dept numbers in column A on sheet1 and Match it with the dept numbers in column A on sheet2 and put the number for that depts grand from column E on sheet2 in column B of sheet1.

[FDibbins]

see if this is what you want...
=INDEX(Sheet2!$E$2:$E$10,MATCH(Sheet1!A2,Sheet2!$A$2:$A$10,0))

[Richard Buttrey]

Hi.

In B2 copied down

Please Login or Register  to view this content.

[gak67]

In the attached file there are 3 options of how you could go about it. VLOOKUP, INDEX/MATCH and SUMIF.
Help.xls

[mehmetcik]

Ok Try this version

[jmcole]

Thank you all very much. All of these work perfectly. Mr. Buttrey I have a question about your formula.... What is this saying? $E$11

[FDibbins]

$ is used to absolute a cell reference, locking it so that when copied, it doesnt change.. it comes in 3 different "flavors...

$A$1 absolutes the entire cell reference, it will not chance when copied down or across
$A1 absolutes only the column, "A" will not change when copied across, but "1" WILL change when copied down
A$1 absolutes only the row, "1" will not change when copied down, but "A" will change when copied across

[Richard Buttrey]

Re#6

Are you asking why use $E$11?

In fact the relevant range of the compound formula is $A$2:$E$11 on sheet 2. i.e. the whole of your table. The reference to 5 of course uses the 5th column in the table.

[jmcole]

Got it, A1:E11 is the table the information is in.
Thank you.