?
Solved

Microsoft Excel: LOOKUP

Posted on 2013-01-09
7
Medium Priority
?
286 Views
Last Modified: 2013-01-12
Hi,

This is related to Microsoft Excel. Somebody (by your own wordings) would you tell me a little bit of  the LOOKUPS and how to use it“ please (some examples or tutorial will be great).

Thank you


tjie
0
Comment
Question by:tjie
7 Comments
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 200 total points
ID: 38761611
Hello,

Can you be a bit more specific?

Lookup formulas can be used to return data by looking up a matching text or number.

You can find samples in the Excel help. Start with VLOOKUP and HLOOKUP.

Cheers, teylyn
0
 
LVL 8

Assisted Solution

by:5teveo
5teveo earned 500 total points
ID: 38761613
Based upon your generic desciption...

Here is a very general examples site using various Excel lookup formula

http://www.techonthenet.com/excel/formulas/lookup.php
0
 

Author Comment

by:tjie
ID: 38761665
Hey teylyn,

What is the difference between VLOOKUP and HLOOKUP.

Thanks
0
Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

 
LVL 24

Accepted Solution

by:
Steve earned 800 total points
ID: 38762187
If you are looking into LOOKUPS it is good to also gain an understanding of the two functions INDEX and MATCH. These are often used to perform the same task as VLOOKUP but are far more versatile and faster than VLOOKUP.

VLOOKUP = Vertical array (Up down data)
HLOOKUP = Horizontal array (Left Right data)
Index-Match-and-Vlookup.xlsx
0
 
LVL 50
ID: 38762210
>> What is the difference between VLOOKUP and HLOOKUP.

With all due respect, but you may want to use the Excel Help to learn the basics and then ask a question if things are not clear after you've read the Help.  Is it really so much easier to post a question on the internet than hitting F1?
0
 
LVL 93

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 500 total points
ID: 38762683
This article (http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_2637-Six-Reasons-Why-Your-VLOOKUP-or-HLOOKUP-Formula-Does-Not-Work.html) will provide a general introduction to VLOOKUP (and by analogy, HLOOKUP), along with common troubleshooting tips.

I second the above recommendations, though, for you to read up on the help entries for the LOOKUP, VLOOKUP, HLOOKUP, INDEX, and MATCH functions.
0
 
LVL 8

Expert Comment

by:5teveo
ID: 38771146
goods luck - thanks for point
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question