Please help for create formula using Isnumber, search and vlookup or index. ansh2792 Jan 17th 2021 Could any one please help to create formula for attached file data. A VBA code also helpfull.Thank YouAnsh