vlookup

[zeldy]

i have a worksheet with al 12 sheets for every mont
inside every worsheet i have a table of salaries of the workers of the company by

salary

name

number of worker

i want do add a summary sheet but the problem is that everymonth there are new workers or workes who leave the company
so i need to use vlookup and iferror?

 

[pecoflyer]

Hi
please post a sample sheet with some data and manually calculated expected results
Are you open to redesigning your workbook ( all info on one sheet) ?

 

[GraH - Guido]

zeldy,
What's the version of Excel you are on?
Depending on it, one can consolidate data from multiple sheets rather easy with Get & Transform or Power Query. Stated this many times already on the forum.
Google some tutorials, it's really simple.

 

[Chief Ace]

i have a worksheet with al 12 sheets for every mont
inside every worsheet i have a table of salaries of the workers of the company by

salary

name

number of worker

i want do add a summary sheet but the problem is that everymonth there are new workers or workes who leave the company
so i need to use vlookup and iferror?

Hi Zeldy,

Just type VLOOKUP in the search box here in the forum and you will get lot's of results that you can use. Or you can go to web browser and type that word and you will get lot of results.

cheers
Chief ace