Forum Discussion
pavankumarmechineni
Aug 20, 2023Copper Contributor
Excel
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.
- pavankumarmechineniCopper ContributorHi....
I have used $ next to the selected ranges and it worked correctly. Thanks.