Formula Required

[manoj18071965]

I have 4 columns in MS office excel 2013. I want formula for whenever i select A value from drop down list B, C, D value should automatically populate in front to A under fields Employee Code, Salary & Variable
[TABLE="width: 472"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]Employee Name[/TD]
[TD]Employee Code[/TD]
[TD]Salary[/TD]
[TD]Variable[/TD]
[/TR]
[TR]
[TD]Deeksha Sharma[/TD]
[TD]2016009[/TD]
[TD]22750[/TD]
[TD]2844[/TD]
[/TR]
[TR]
[TD]Babban Yadav[/TD]
[TD]2016012[/TD]
[TD]17500[/TD]
[TD]2188[/TD]
[/TR]
[TR]
[TD]Komal Sharma[/TD]
[TD]2016018[/TD]
[TD]26000[/TD]
[TD]3250[/TD]
[/TR]
[TR]
[TD]JaanPal[/TD]
[TD]2016022[/TD]
[TD]20000[/TD]
[TD]2500

[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Let A:D of Sheet1 house the data you posted.

Let A2 of Sheet2 house a drop down list from which an employee name can be selected.

Assuming that the selected name can just occur once in Sheet1 (the salary field implies this assumption), in B2 enter and copy across:

=VLOOKUP($A2,Sheet1!$A:$D,MATCH(B$1,INDEX(Sheet1!$A:$D,1,0),0))

where B1 = Employee Code, C1 = Salary, and D1 = Variable.

 

[ahmad08]

formula.xlsx - Google Drive

 

[manoj18071965]

Thank you!

 

[ahmad08]

This will be aplicable only until number of employees are less than 65.