[ excel ] vlookup

syntax

VLOOKUP(key, table_array, column to show, result search)

vlookup_example

 

image credits from about.com link is provided below

result search can be 0 ( ตรงตัว ) or 1 ( ใกล้เคียง )

example

=VLOOKUP(B2, entity!B2:D6709, 3, 0)

if we want to drag column to copy, don’t forget $.

example

=VLOOKUP(B2, entity!B$2:D$6709, 3, 0)

NOTE : the lookup column should be at the first column of table_array.

ref : http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm
http://snasui.blogspot.com/2009/12/vlookup.html
http://www.excelexperttraining.com/forums/showthread.php?t=8405

TIPS

concatenate

=CONCATENATE(G34, "", H34)

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s