match list

J

Jai

I have two lists in two seprate sheets. I need to create a formula/marco to
match the lists and compare the amounts. Sheet A has reference ID and payment
amount due, sheet b has reference id and paymnet received. I need to compare
two sheets and find out differences on sheet b and on sheet a find out
outstanding amounts due. Please help with macro or formula For e.g.:
Sheet A
column A Col.B
hh11230 356.55
hp12598 400.00
rs56855 1298.49

Sheet B
Col.A Col.B
hh11230 356.55
hp12598 400.00

Thanks in advance
Jaishree
 
D

driller

Jai,

is it possible that the reference id on column 1 of sheet b can be repeated
twice..
e.g. payment received comes with 2 or more partial payment ?

regards,
driller
 
J

Jai

Hi,

Its a possiblity, that's I am not using vlookup function as vlookup function
is only finding first match. Please help with vlookup function as well or any
other function/formula etc.
Thanks
Jai
 
D

driller

Jai,

its a common expectation...u may now elaborate ur samples of data pertained
for the formula criteria n param. to make it clear in laymen terms.

regards,
driller
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top