Working Hours :

Monday - Friday, 10am - 06pm

+911244962543

By using this method/formula can find any data if data type is mismatched.

Formula: VLOOKUP(1*G2,$C$2:$E$23,3,0)

Syntax: VLOOKUP(1* for convert change data type form text data to number data, G2-Lookup Value, Select table array/Data range,3 for column number, 0 for exact match)

Normal VLOOKUP function will not work if Lookup value data type is mismatch, so in that case only this formula will work for finding any data/records in Excel.