Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 30th 06, 09:33 PM posted to microsoft.public.excel.misc
jseabold
 
Posts: n/a
Default Complex if test program possible? If "value" "value", paste "value" in another cell?


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


--
jseabold
------------------------------------------------------------------------
jseabold's Profile: http://www.excelforum.com/member.php...o&userid=30990
View this thread: http://www.excelforum.com/showthread...hreadid=506548


  #2   Report Post  
Old January 30th 06, 10:01 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Complex if test program possible? If "value" "value", paste "value"in another cell?

Kind of like a =vlookup() based on multiple cells to match on?

You can use this kind of syntax:

=index(othersheet!$c$1:$c$100,
match(1,(a2=othersheet!$a$1:$a$100)*(b2=othersheet !$b$1:$b$100),0))
(one cell)

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.

And just keep adding more stuff to that product portion of the formula:

=index(othersheet!$d$1:$d$100,
match(1,(a2=othersheet!$a$1:$a$100)
*(b2=othersheet!$b$1:$b$100)
*(c2=othersheet!$c$1:$c$100),0))

(still an array formula)

jseabold wrote:

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

--
jseabold
------------------------------------------------------------------------
jseabold's Profile: http://www.excelforum.com/member.php...o&userid=30990
View this thread: http://www.excelforum.com/showthread...hreadid=506548


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Instead of a negative number, I'd like to show zero... Dr. Darrell Excel Worksheet Functions 6 December 7th 05 08:21 PM
excel - numbers as text Thuferhawat New Users to Excel 12 January 24th 05 09:29 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM
sending data from one cell to another (not using copy & paste) Charlie Payne Excel Worksheet Functions 3 December 6th 04 03:28 PM
copy paste cell character limit Fred Excel Discussion (Misc queries) 1 December 2nd 04 08:58 PM


All times are GMT +1. The time now is 03:34 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017