How to lookup values

[omer]

Hi,

I have 2 sheets: Sheet1 and Sheet2

Sheet1 has the following budget centers in Column "A":

1430100
1430200
1430300
1430400
1430500
1430600

Sheet2 has the same budget centers in Column B (just not
as organized) and column C has a bunch of expenses for
those budget centers

1430600 5
1430400 8
1430200 3
1430500 1
1430100 456


Question: How can I make sure that expenses that
correspond to budget centers in Sheet2 are copied over to
their respective budget centers in Sheet1

Expected results of Sheet1:
1430100 456
1430200 3
1430300 (Leave blank if no values in sheet2)
1430400 8
1430500 1
1430600 5


Thanks for the help in advance
Omer

 

[Peo Sjoblom]

One way

=IF(ISNA(MATCH(A2,'Sheet2'!$B$3:$B$100,0)),"",VLOOKUP(A2,'Sheet2'!$B$3:$C$10
0,2,0))

put the formula in B2 (assuming A2 sheet1 is the first cell with the budget
centers) and
copy down, adapt ranges cell references to fit

 

[omer]

Thanks for the help.

But there is an error message. "You have entered too many
arguments for this function"

Please help

Thanks
Omer

 

[Frank Kabel]

Hi
Peo's formula looks o.k. for me. Have you entered it in exactly the
same way. You may post your formula to let us check it