Matching colums

[tim9]

I have two tables. One with my invoice # and amount.The other one with my invoice# and amount received from customers. How can I insert the amount received from table two and insert it next to the matching invoice # on table one.

Thanks

 

[Aladin Akyurek]

I have two tables. One with my invoice # and amount.The other one with my invoice# and amount received from customers. How can I insert the amount received from table two and insert it next to the matching invoice # on table one.

Thanks

Let A2:B25 house table 1 and J2:K15 house table 2.

=INDEX($K$2:$K$15,MATCH(A2,$J$2:$J$15,0))