Thread: Look up and replace

I have a colum of customer ids then I have aother colum of customer ids with a status number in the next colum

I've uploaded a sample colum a has the formula
the problem is it is not exact if it doesn't find the customer it goes down 1 row or so and puts in a number. I need to know if found replace if not fund have a 0 or a null or somehting

any help would be appreciated

that worked great!
I have one more I tried the sumif and it didn't work I have the lookup in there but don't trust it

I want to compair 2 sets or custid's I want to lookup in colum a id from colum d and compair the to rf scores and show the difference if not found a zero woudl be fine

if what I have works I'm just confirming

Once again thanks

g2: =IF((SUMIF(A:A,D2,B:B))>0,E2-(SUMIF(A:A,D2,B:B)),0)

The above worked when I used the
G2: =LOOKUP(9.99E+307,CHOOSE({1,2},0,VLOOKUP(A2,D:E,2,0)-B2))

I still got numbers in colum g for custid that were not found

The above formula works

Thanks for all your help