i found the screenshot hard to read.
but what i think you're trying to do is link the numbers is list 1 to the account numbers in list 2. ie. if cell A2=1 then cell D2=Acc5000
is that correct?
if thats the case you can use the IF formula to link them up
__________________
An injustice anywhere, is an injustice everywhere
I always sign my facebook comments with ()()===========(}. Does that make me gay?
- Filthy
|