Copper Contributor

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. 



2 Replies



Not sure whether Pivot Table can help? 

I have used $ next to the selected ranges and it worked correctly. Thanks.