Vlookup was my go to formula for things like this, that is before someone pointed me to the INDEX/MATCH function.
It's a very powerful combination that doesn't require you to sort a list or insert additional search/sorting columns. You can find a very useful explination on the contextures website.
Your problem: if your set up is that you have your data on seperate sheets and the only lisason between BILLS and CUSTOMER is an account number
Sheet 1
Sheet2
In sheet 2 column C (Bill) - apologies for leaving off the column numbers, but hopefully you get my drift) you put the following formula:
=INDEX(Sheet1!$B$2:$B$5,MATCH(A2,Sheet1!$A$2:$A$5,0))
This basically says: =INDEX(look in here and bring me the cell content/value from here,MATCH(where this cell value,is found in this list,and make it an exact match))
(the contextures website explains it better)
Anyway, the great thing about Index/MAtch is that it's powerful, and you don't need to sort your lists (as you can see from my example). also, it one of those things that you can build on and soon you'll be finding and retreiving things from all over the place. But it takes a little time to get your head around some of the things - but it's worth it.
..however, the VlookUp will be something you can use should you not feel comfortable with the Index/Match.
Hope it helps.
Mike.