General discussion

Locked

Vlookup

By 1image ·
Hi, i'm a student struggling with Vlookup i need a really slow step by step indepth instruction on how to use this function. I'm trying to return values such as customer name,code and so on (i have offered half the points i have because i am weary from searching the net!) thanking you in advance.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by chitosunday In reply to Vlookup

Syntax :
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
The lookup value is the one you want to search and match, the table array is your database range,
the col index refers to which specific column you want to get the result meaning no. 1 means
the first column it will get the output, range lookup is what type of search and match you want, zero or false is a specific search, true or 1 is based on equal or lesser than usually for numbers particularly tax tables ) in your example , you need to search specific item so it should be zero or false.

Collapse -

by bschaettle In reply to Vlookup

This isn't a complete answer, but one thing I've found very useful when using VLOOKUP is to use a "named range" for the table_array. This makes reading the formula MUCH easier. Also, keeping the lookup table (table_array) on a separate worksheet helps keep things organized, as well.

Collapse -

by codenumpty In reply to Vlookup

Don't forget the table/database containing the data you are looking up must be sorted in ascending order for it to work properly

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums