Is there a quick and easy way to get
=IF($E$93=1,A3,IF($E$93=2,B3,IF($E$93=3,E3,IF($E$93=4,H3,IF($E$93=5,I3,IF($E$93=6,G3,IF($E$93=7,J3,IF($E$93=8,K3,IF($E$93=10,S3,IF($E$93=11,T3,""))))))))))
to work better?
I did this in the formula bar, but Im about to add more, and it's getting cumbersome, maybe some VBA?
You could use Select Case in VBA but you would have to put that code in an Event-macro to trigger the execution.
The next question then would be when do you want the cell with the formula in it to be evaluated ? When you change the value in E93 or ...
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.
Thread Closed.
https://www.excelforum.com/excel-gen...else-help.html
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks