Hi everyone,
I have excel workbook with customers data. I have four sheets with in it. First sheet is orders, second sheet is salesperson, third sheet is customers and fourth sheet is city.
Now I need to match city ID column in customer sheet with city sheet having City ID and city names. Same with salesperson ID in order sheet with Salesperson name in salesperson sheet.
I was using Vlookup and I got fews cells matching correctly but remaining wrongly or showing #N/A. I tried editing few cells individuals but the results are matching wrongly.
How can I resolve this.
