I am facing with a fuzzy issue working with vlookup. I require to do a partial search in a range of cell.
I have two sheets. Worksheet1 contains list of IDs for ex: 000A2324GH1100
Worksheet2 is the main database where I need to do a lookup.
For ex. I want to list in Worksheet1 all the IDs that contains text 'A2324G' from Worksheet2. Could you please help me on how can I do this. I have tried FIND & SEARCH functions but did not help.