cdcsolutions
Board Regular
- Joined
- Nov 22, 2011
- Messages
- 55
Is there anyway a person can use the Vlookup to lookup a list by using partial information. Eg. In Cell B1 enter 8c-26-062-08 and it will find the info from Column C from a list that contains Eg. Bertsei 199/08c-26-062-08s4/02. By typing in column "B1" 8c-26-062-08, I want A1 to list "Bertsei 199/08c-26-02-08s4/02 which comes from Column C of a different sheet. My problem is that I want to type in only parts of the full description to result in the full description auto filling.
Help please if this is possible to do. I'm thinking of using Match? Thanks!
Help please if this is possible to do. I'm thinking of using Match? Thanks!