VLOOKUP vs LOOKUP

[Kruzer]

I'm relatively new to the VLOOKUP and LOOKUP formulas

I have to two sheets - 1st sheet is the output, the 2nd sheet is the data populating several rows and columns.

I want to be able to add up one column in sheet2 and output the result in one cell in sheet1. I attempted to added one column of data using VLOOKUP, but I just don't seem to be able to get the parameters right.

What are these parameters:
Lookup_value
Table_array
Col_index_num
Range_lookup

Thanks,

Dano
dskryzer@hotmail.com
What's your major malfunction

 

[mymou]

Hi Kruzer

Not really VBA but hey...

Lookup_value - is the value you are looking for
Table_array - Where you are searching (remember use absolute references)
Col_index_num - Which column you want
Range_lookup - usually false - if looking for exact match

So
=VLOOKUP(A1;Sheet2!$A$1:$B$7;2;FALSE)
is looking for A1 in Sheet2!A1:B7 (note the value in A! MUST be contained in the left most column ie Sheet2!A) returning what ever value is in column B, where A1 matches exactly.

Hope this helps.


Stew
"Even a stopped clock tells the right time twice a day."