V-look up

This query is : Resolved

Report Abuse Follow Query Ask a Query

Querist : Anonymous

Querist : Anonymous (Querist)

17 October 2012 how to you V-LOok up in excel sheet please provide me details

deepali agarwal

deepali agarwal (Expert)
Follow

18 October 2012 V-look up allows you to look up values in a table that are listed in column format (how most tables are laid out), given another value (let’s call this the “key”). Excel also has a sister function called hlookup (h = horizontal) that can be used to look up values in rows.
Vlookup’s format looks like the following:

=vlookup(lookup value, table where values reside, column # where values are located, false)

Message likes : 1 times

deepali agarwal

deepali agarwal (Expert)
Follow

18 October 2012 u can view the following tutorial.
http://www.youtube.com/watch?v=KXhM-wBM7U4

Message likes : 2 times

Upgrade to CAclubindia Pro. Subscribe Now!