VLOOKUP for spreadsheet compare
 

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.

VLOOKUP for spreadsheet compare
 

Hi
in sheet 1 try
=vlookup(A2,worksheet2!$A42:$B$230,2,false)
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany


bbquestion2003 wrote:
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.