blackie42
03-31-2008, 03:33 AM
Hi
Wasn't sure how to title this.
What I want to do is have a cell in sheet1 return a certain value dependent on whats input to a cell on another sheet. Not sure whats the best way to do it.
e.g.
If cell A1 on sheet2 = Bank1 then cell A1 on sheet1 = "00001111"
If cell A1 on sheet2 = Bank2 then cell A1 on sheet1 = "00002222"
Could use a lookup table but can it be done in VBA?
thanks for any help
Wasn't sure how to title this.
What I want to do is have a cell in sheet1 return a certain value dependent on whats input to a cell on another sheet. Not sure whats the best way to do it.
e.g.
If cell A1 on sheet2 = Bank1 then cell A1 on sheet1 = "00001111"
If cell A1 on sheet2 = Bank2 then cell A1 on sheet1 = "00002222"
Could use a lookup table but can it be done in VBA?
thanks for any help