can someone help me with Vlookup in Excel.

foolanger

Senior member
Dec 11, 1999
597
0
0
I am currently own cell phone store and am working on something to help me with computing comission for my employees. I'm trying to do it in Excel and need to use the Vlookup function so that i can type in Nokia 3390 and a price will pop up. Is there a way of using vlookup so that it will recognize names like Nokia 3390 and not just numeric values? thank you for all your help guys.

 
Jan 18, 2001
14,465
1
0
VLOOKUP
See Also

Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find.

Syntax

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string.

Table_array is the table of information in which data is looked up. Use a reference to a range or a range name, such as Database or List.

If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted.


You can put the values in ascending order by choosing the Sort command from the Data menu and selecting Ascending.


The values in the first column of table_array can be text, numbers, or logical values.


Uppercase and lowercase text are equivalent.
Col_index_num is the column number in table_array from which the matching value must be returned. A col_index_num of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on. If col_index_num is less than 1, VLOOKUP returns the #VALUE! error value; if col_index_num is greater than the number of columns in table_array, VLOOKUP returns the #REF! error value.

Range_lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, VLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.

Remarks

If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than or equal to lookup_value.


If lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error value.


If VLOOKUP can't find lookup_value, and range_lookup is FALSE, VLOOKUP returns the #N/A value.

 

CPA

Elite Member
Nov 19, 2001
30,322
4
0
Yes, you just need to make sure that the spelling, spacing and capitalization matches. Vlookup is very finicky when trying to match the lookup_value.
 

foolanger

Senior member
Dec 11, 1999
597
0
0
Next question.. how do i do an "IF" function.. that is my last question.. i promise. :)
 

foolanger

Senior member
Dec 11, 1999
597
0
0
another question for you excel buff's out there.. Is it possible to set this up.. I want just categories of "At&T wireless $29.99", AT&T Wireless $39.99, nextel 59.99 and so on.. when we download our stuff from our systems to excell.. it has a lot of extra stuff on it.. like. AT&T wireless 39.99 data plus voice and etc.. can we make it just recognize the 39.99 and automatically put in the necessary value.. can i use vlookup for this?
 

minendo

Elite Member
Aug 31, 2001
35,558
16
81
Originally posted by: foolanger
Next question.. how do i do an "IF" function.. that is my last question.. i promise. :)
=if(lookup value, value if true, value if false)