joshdadbin
New Member
- Joined
- Oct 13, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- MacOS
Hello All,
I am looking to create a query to help me with my accounting. I have a table (sheet 1), and I would like for the query to pull answers from this table of category.
So Sheet 2 would have a list of transaction, and if the name of that transaction (CITY PARKING METER) contains certain text (PARKING) It will shoot out a category or sub category.
I am familiar with INDEX MATCH, but not ISNUMBER or PowerQuery
I am looking to create a query to help me with my accounting. I have a table (sheet 1), and I would like for the query to pull answers from this table of category.
So Sheet 2 would have a list of transaction, and if the name of that transaction (CITY PARKING METER) contains certain text (PARKING) It will shoot out a category or sub category.
I am familiar with INDEX MATCH, but not ISNUMBER or PowerQuery