If statement - Loop?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top