J
jseabold
I am fairly new to the world of Excel programming but have decen
familiarity with the embedded functions. However, I was wondering i
it is possible to write a program or perhaps a function (though I don'
think a simple if test will work, but that's the basic idea, it jus
seems much too tedious!) which will go down through each cell in
column of many cells, evaluate that column, then evaluate anothe
column, then possibly another column, and then paste a certain strin
of text in another column. For example, if A3 = "Disney", if B3
"Orlando," if C3 = "August" then "Sweltering Heat" would be posted i
D3. The if tests would also need to differentiate between hundreds o
possible strings of text and the then result would need to able to pos
hundreds of different strings as well. Any help would be muc
appreciated. I'm not asking for the program to be written, just
general direction to go in. I'm pretty comfortable with a computer an
programming once I know where to go. Thanks for any help
familiarity with the embedded functions. However, I was wondering i
it is possible to write a program or perhaps a function (though I don'
think a simple if test will work, but that's the basic idea, it jus
seems much too tedious!) which will go down through each cell in
column of many cells, evaluate that column, then evaluate anothe
column, then possibly another column, and then paste a certain strin
of text in another column. For example, if A3 = "Disney", if B3
"Orlando," if C3 = "August" then "Sweltering Heat" would be posted i
D3. The if tests would also need to differentiate between hundreds o
possible strings of text and the then result would need to able to pos
hundreds of different strings as well. Any help would be muc
appreciated. I'm not asking for the program to be written, just
general direction to go in. I'm pretty comfortable with a computer an
programming once I know where to go. Thanks for any help