B
bbquestion2003
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.
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.