returning values from other worksheets

[Guest]

I have a worksheet with checks that have been written. Column A, check number
column B, amount. I have another worksheet with checks that have cleared the
bank. Column A check number and column B amount. I want to search Column A
for matches to column A and return the amount in column B for the amount the
check cleared the bank for so I can compare it to the amounts written. These
lists are huge and would take weeks by hand.

 

[Frank Kabel]

Hi
have a look at VLOOKUP for this:
http://www.contextures.com/xlFunctions02.html