assuming your data are in Sheet 1 and the 'Amount 1 (key' value are in A2
down on another sheet put this in b2 and drag down

VLOOKUP(A2,Sheet1!$A$2:$B$13,2,FALSE)

Mike

"JHL" wrote:

I have two lists in separate spreadsheets, illustrated below. How do I find
a match using the Amount1 field as the key, and match to the second list with
the correct batch number? Both lists are unequal in the number of records.

Thanks for any help.

Amount Batch Number Amount1 (key)
3.45 8123953001 3.45
3.88 8123971001 3.88
4.40 8123872001 4.40
4.43 8123A42001 4.43
4.45 8123970001 4.45
5.03 8123681001 5.03
5.15 8123839001 5.15
5.49 8123571001 5.49
5.49 8123803001 5.49
5.49 8123804001 5.49
5.49 8123983001 5.49
5.49 8123A52001 5.49