Hi,
The Lookup value has to be from a list of unique data.
When your lookup value is 5.49, which batch number do you actually want
returned?
Also, something I didn't understand from your original post, You said you
had 2 lists in separate spreadsheets, but your data is arranged in 3 lists
(Amount, Batch Number, Amount 1)
Regards - Dave.