LindenWolf
New Member
- Joined
- Feb 28, 2012
- Messages
- 30
- Office Version
- 365
- 2016
- Platform
- Windows
Good afternoon. I am trying to do a lookup that is a bit more complex than I imagined. I need to basically find a word in a column to determine which value to return. The kicker is that I need to ensure that mutilple finds are a match to pull in the right value. For Example:
Headings i have are in the following order:
ColA-ColG
Fund, Function, Account Org, Pic,LOC,Account
I have a matrix that has the criteria
I need to pull in the Category field of the look up table but I have Location that has several locations in it like 201,203,204etc...each number represents a location the same with Function, Pic, Fund, and GL
In GL if it is blank it means that all GL's are possible, if there is a value then only that value is possible.
I'm happy to attach a file if someone can tell me how to do so.
Please know that I realize there has to be a better way than excel but this is currently my only option at the moment.
Thank you for any help you can provide.
Headings i have are in the following order:
ColA-ColG
Fund, Function, Account Org, Pic,LOC,Account
I have a matrix that has the criteria
I need to pull in the Category field of the look up table but I have Location that has several locations in it like 201,203,204etc...each number represents a location the same with Function, Pic, Fund, and GL
In GL if it is blank it means that all GL's are possible, if there is a value then only that value is possible.
I'm happy to attach a file if someone can tell me how to do so.
Please know that I realize there has to be a better way than excel but this is currently my only option at the moment.
Thank you for any help you can provide.