Dear Sir,
I have two Sheets, one is software entry and another one is manual entry.
I have put entry numbers from Manual sheet to software sheet.
Due to large data size I wanted to apply lookup.
Problem : the date and vehicle numbers are matching but it’s not working for helper column because Vehicle numbers format is different in both sheet.
I have two Sheets, one is software entry and another one is manual entry.
I have put entry numbers from Manual sheet to software sheet.
Due to large data size I wanted to apply lookup.
Problem : the date and vehicle numbers are matching but it’s not working for helper column because Vehicle numbers format is different in both sheet.