Hi,
Is there any way to shorten the below formula : I am not able to use index and match because it needs to refer to more than one column e.g, if its local special or locally sourced column AC needs to be checked and if its Factory Source or Factory Special column X needs to be checked:
Thank You in advance!!
Please Login or Register to view this content.
maybe your file in advance?
I am sorry I did not understand !!
We wold have to see what you are working with, to determine if that is a valid comment, please upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.I am not able to use index and match because it needs to refer to more than one column
In the mean time, you can probably shorten that with wild-cards....
OR(AND(F1140="locally Sourced",AC1140=$AC$1329),AND(F1140="local Special",AC1140=$AC$1329))
can probably be shortened to...
AND(F1140="local*",AC1140=$AC$1329)
(untested)
Also, it is easier to trouble-shoot a formula if you break it down with spaces like this...
Formula:
Please Login or Register to view this content.
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
Hi.. Thank you for the response and sorry for not presenting the data more clearly.
I have attached the excel with a simple format and reduced option so please have a look and let me know if they can be shortened.
FDibbins, I tried the wild card Local* but if did not work, is there any other alternative?
Many thanks for all the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks