I'm building a spreadsheet to categorize entries. I use a list of known entries and vlookup to pull the category for each item. It works well if the search key is exact. But is there a way to have it search based on a variable or changing key?
I'm including a sample sheet that shows the basic concept looking for variations of entries.
Thank you in advance!
Best regards
- Maurice
worksheet or Tab name : Log
Cell B2 formula , Drag down
Formula:
Please Login or Register to view this content.
Perfect! Thank you. I would never have thought of that technique
I was wrong. It worked for the table I attached but when I made changes it stopped working. The only changes I made were expanding the "Types" columns to allow more entries and changing the column that it looks up the results.
Any suggestions?
Please Login or Register to view this content.
ATTN : The last one cannot be distinguished because the TEXT strings are connected together, EXCEL will treat it as a complete one, unless you separate it for processing
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Pls try
worksheet or Tab name : Log
Cell D2 formula , Drag down
Formula:Please Login or Register to view this content.
If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.
Last edited by wk9128; 03-02-2023 at 09:52 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks