Solved

Microsoft Excel: LOOKUP

Posted on 2013-01-09
7
248 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
Ingeborg Hawighorst earned 50 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 125 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 24

Accepted Solution

by:
Steve earned 200 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

Expert Comment

by:Ingeborg Hawighorst
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 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 125 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now