Vlookup tool with multi Criteria

Crescendo

New Member
Joined
Aug 6, 2014
Messages
6
Hello All,

I am Not a excel genius.

I am trying to make a file in which i canauto fill information of employee on one single page. I have one file (Workbook 1)which has 52 tab (Each weekending Sunday). I want to make a formula in which if i put week ending and Employee number it gives me their performance data from another workbook (IE Workbook 1)

scenario

If Tab name match to cell D4, than find employee number from the list and give me data which i need. (There are 11 Performance data which i need from each tab)

Please please help me with this.


Employee IDEmployee NamePerformance OnePerformance 2
123ABC84%95%
548HYZ100%68%

<tbody>
</tbody>

I want formula by which i can get those information and i can change cell value to respective performance which i need.


All Help is really appreciated. Thanks in Advance.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Crescendo

New Member
Joined
Aug 6, 2014
Messages
6
I would put all your data in one table and use a pivot table to analyze the data.


Thanks for response but its for making report which employee can see every week. There is format of document which i am willing to make from it.
Pivot table is not option for me. I am trying to create something which is kind of similar like mail merge.

Thanks
Crescendo
 

Watch MrExcel Video

Forum statistics

Threads
1,130,441
Messages
5,642,133
Members
417,258
Latest member
amk1979

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top