The lookup function looks up the parallel value of the value you have
specified. The direction of looking up is depends on the formula. That is h
lookup or v lookup.
To understand the concept let us create a data on work sheet as follows.
Step 1 in a1 type apple.
Step 2 in b1 type mango.
Step 3 in c1 type orange.
Step 4 in a2 type 40.
Step 5 in b2 type 50.
Step 6 in c2 type 60
Step 7 in a3 type 70.
Step 8 in b3 type 80.
Step 9 in c3 type 100
Now you have a table of 3 columns and 3 rows. Let us use the formula h
lookup in d1, so go to cell d1 and type the following formula
Note use your arrow keys to read the formula
=hlookup("apple",a1:c3,3,)
In the above formula "apple" is the criteria value a1:c3: is the data field
and 3 is the row line from which the value will be returned.
Firstly the formula will search for "apple" in a data field, which is in
cell a1.
Then it will search for the parallel value in the third row because we had
typed 3 in the formula. So it will return the value from a3 which is
parallel to "apple" or a1. Which is=to 70.
Vertical lookup returns the value from left to right.
In the above formula if we change the hlookup to vlookup then it will return
the value orange.
Because "apple" in a1 is parallel to "orange" in c1.
For more clarifications you can Skype me on zoher.kheriwala
Send me an IM before calling.
----- Original Message -----
From: "Nazrulhuda khan" <[email protected]>
To: "accessindia" <[email protected]>
Sent: Friday, February 24, 2012 3:15 PM
Subject: [AI] excel 2003 charts and pivot table accessing methods
Hi Arvind and Others,
Can you please also send me the methods of the same charts and pivit
tables, V look up and h look up in excel 2007. I have recently got the
job and I have to do these things in accordance of my profile.
I will look forward your valueable reply as soon as possible.
Regards,
Nazrulhuda Khan.
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/[email protected]/
To unsubscribe send a message to
[email protected]
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
