Excel doubt

[nikhilboorla]

Any one know how to update column(salary) in 2nd sheet based on column(empid) in 1st sheet using vlookup in Excel??

[tom brady]

Pivot table 

[nikhilboorla]

3 minutes ago, tom brady said:

Pivot table 

Can you explain how to do

[phatposts]

https://www.ablebits.com/office-addins-blog/compare-two-columns-excel-vlookup/

Pivot table works best in my opinion. Simple stuff ki above link for vlookup works

[34DD]

43 minutes ago, nikhilboorla said:

Any one know how to update column(salary) in 2nd sheet based on column(empid) in 1st sheet using vlookup in Excel??

How is job ?

[dasari4kntr]

1 hour ago, nikhilboorla said:

Any one know how to update column(salary) in 2nd sheet based on column(empid) in 1st sheet using vlookup in Excel??

Define name…for the list/column in first sheet….

In the second sheet  vlookup use the list name …