Hello All,
In attempting to port an Access database/report to Excel, I would like to come up with a way to replicate the logic of the following Access query, but without actually hardcoding the values that are being checked for (in a field/column).
Currently, during the many organization restructures/department name changes, the services of a tech-savvy (SQL-aware) user is required to maintain/change these queries, but I would like for an ordinary user to make changes in a table, without having to touch/change an Excel formula when changes occur.
So, in the code above, [Business Group] would be a column in Excel, and I would like to check the value of each cell in that column (for all rows of course) to see if it begins with the word "Renewable", but without actually hardcoding the "Renewable*" into the formula.Please Login or Register to view this content.
Likewise, cells in the column named [Division] have to be checked to see if they begin with words such as "Southwest", "Northwest" etc., but again, those wildcard-suffixed terms must not be embedded in the formula, but rather, be looked-up in a user-maintainable table.
Is this do-able, and if yes, what would the formula be, and how would I setup the table?
Thanks
Bookmarks