Compare data with a specific code to a list of codes

[Robert72]

Hi,

I got 2 sheets. (1 called "Revenue", the other "101")
in the sheet revenue are department codes (variable 100 to 999)
they are situated in row "B". the corresponding data in row "D".
this data needs to be transported to the sheet "101"

in the sheet "101" are put the numbers 100 to 999 in row "A"
in row "B" we need the data from the revenue sheet that is corresponding with the department code.

could somebody help me?

kind regards
Robert

 

[obiron]

If each department only appears once, then you should be able to do this with a VLOOKUP().

If it appears more than once you will be better off using SUMPRODUCT()