How to lookup values

  • Thread starter Thread starter omer
  • Start date Start date
O

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
 
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
 
Thanks for the help.

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

Please help

Thanks
Omer
 
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 :-)
 
Back
Top