Excel Vlookup question
By daylstone
@daylstone (126)
Philippines
January 18, 2009 2:54am CST
is it possible for me to pull out information on one sheet and automatically average it on another?!
for expample:
I have customer 1 with 654, 546, 654 on different cells. I want to be able to look it up on another sheet and then automatically average the three...
I don't know if there is any way for us to do this.. but I believe it is possible, (nothing is impossible, hehehe) I just don't know how to do it...
1 response
@venkataraman_vc (5293)
• Chennai, India
18 Jan 09
Actually Vlookup works in a different way.
For example you have Employee Id, Employee name, and other details in a sheet. You can use this formula to retrieve the employee name by just typing the id only.
Example:
Sheet1 contains columns Emp_id, Emp_name, Emp_salary (Column header is Row Number 1. Data starts from Row number 2)
Emp_id Emp_name Emp_salary
10001 xxxxxxxxx 25,000
10002 yyyyyyyyy 10,000
10003 zzzzzzzzz 15,000
In Sheet2, in Cell B1 type the following formula:
=vlookup(A1,sheet1!A2:sheet1!C4,2)
Now, in Sheet2, in Cell A1, type 10001 and press enter. Watch what happens?
The employee name 'xxxxxxxxx' should appear on B1 of sheet2.
Now type 10002 in A1 and press enter. What happens? The employee name 'yyyyyyy' should appear on B1.
