Could you please explain where you get the account number from?
What should be placed in column D?

Also: when you write "if data in cell B = "text" ", do you mean if cell B
contents contains text (no number) ?

HTH
--
AP

"George" a écrit dans le message de
...
I want to run an If statement or loop macro over two columns (say Col B
and
C) that asks if data in cell B = "text" and cell C = "name" then return
"account number" to column D.
e.g
Cell B1 = ABC Bank
Cell C1 = Account Name
Cell D1 = Destination cell = Account number
This loop needs to be done on more than one Account Name.
Your help would be greatly appreciated.
George