Excel Look up. What is it for ?

Question

Plz help. I have 4 days to learn what Excel look up is for and more scarely, how to use it.

Answer 1

Try Google for more.

http://support.microsoft.com/kb/214252

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

http://www.exceltip.com/exceltips.php?view=category&ID=112

Answer 2

Great feature. Should take you less than an hour to learn.
Say you have 2,309 sales in all 50 states, but each state has a differnent sales tax then you need to look up the tax rate.
So a sale in SD will find the SD in the tax table and then put in the tax rate.
Vlookup and Hlookup, and also it is better to arrays.
Open up a spread sheet and start hacking around.

Answer 3

Returns a value either from a one-row or one-column range or from an array . The LOOKUP function has two syntax forms: the vector form and the array form.If you want to Look in a one-row or one-column range (known as a vector) for a value and return a value from the same position in a second one-row or one-column range then see Vector form Use the vector form when you have a large list of values to look up or when the values may change over time.
If you want to look in the first row or column of an array for the specified value and return a value from the same position in the last row or column of the array then see Array form Use the array form when you have a small list of values and the values remain constant over time.

Answer 4

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

Happy learning. It's pretty detailed, and shows example.

Answer 5

office.microsoft.com click help and how-to, many, many tutorials.