vlookup comparison

[manojxls]

HI
I have data like

A	B	C	D	E	F
account	old.count	account	new.count
12345678	2	12345678	5	=5-2=3

A |B | D | E |F |REQUIRED ANSWER
account# |old.count | account# | new.count |
12345678 |2 |12345678 |5 |=VLOOKUP | =5-2=3
23456789 |4 |23456789 |4 | |=4-4=0
78945612 |2 |78945612 |3 | | =3-2=1
78945615 |1 |78945615 |3 | |=3-1=1
|45678912 |2 | |=NEW ACCT

Can anyone help me to vlookup or any formula so i compare AB column(OLD COUNT) with DE column(NEW COUNT) SO i can get difference in count., please suggest.thanks Manoj

 

[CA_Punit]

Can you post a sample data in xl2bb (Available in right hand side of reply area) .
Your post is not readable for me

 

[gaz_chops]

Not sure from your jumbled data! But maybe

=IF($D3="","New Account",$E3-VLOOKUP($D3,$A$3:$B$7,2,0))

 

[CA_Punit]

I think this will help

=SUBSTITUTE(E2,"|","")-SUBSTITUTE(vlookup(D2,A:B,2,0),"|","")

 

[CA_Punit]

If the Number contain text "|" then use that otherwise change the "|" to other text.

 

[manojxls]

Not sure from your jumbled data! But maybe

=IF($D3="","New Account",$E3-VLOOKUP($D3,$A$3:$B$7,2,0))

View attachment 17873

Not sure from your jumbled data! But maybe

=IF($D3="","New Account",$E3-VLOOKUP($D3,$A$3:$B$7,2,0))

View attachment 17873

Thanks it help me
Mean while d last row have account number and last row of a column will blank

 

[gaz_chops]

Not sure I understand, maybe

=IF($A3="","New Account",$E3-VLOOKUP($D3,$A$3:$B$7,2,0))

 

[manojxls]

If the Number contain text "|" then use that otherwise change the "|" to other text.

"|" This character I use for border as I keying from phone

 

[CA_Punit]

ok. may be post 7 can help you