Seems simple

2 worksheets, 2 columns

Col. A = Acct#
Col. B = Amount
Col. C = result of look up

Take worksheet 1 acct# and look up worksheet 2 acct# and when you find
an exact match get the amount in column b of worksheet 2. 230 rows of
data in worksheet 2, 236 rows in worksheet 1. Acct#s in 1 that are
not in 2, vice versa.

=vlookup(worksheet2!A2:B230,2,false) (I've tried multiple different
ways and can't get it to work)

Doesn't work. What am I doing wrong ?

Thank you in advance.