Solved

Microsoft Excel: LOOKUP

Posted on 2013-01-09
7
254 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

825 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