Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Vlookup function

Vlookup function

Vlookup function

I've just discovered this marvelous function, for those out there who don't know it :::::: you Must try

RE: Vlookup function

Pretty powerful I agree. In effect you can interconnect 2-D tables to form relational databases.  A very basic and necessary function in the database world.

RE: Vlookup function

Another good one is the HLookup function.... does the same thing VLookup, but instead of reading columns, it uses rows.  Using them in conjunction is a good tool to know how to use!


RE: Vlookup function

You may be interested in PUP from J Walkenbach.  He has an impressive set of add in tools for excel for a modest price.  The version I have has a VInterpolate and Hinteroplate lookup type function.  It will interpolate between a table of values, very usefull to me many times.  Here is the link to his web site  http://www.j-walk.com/ss/


RE: Vlookup function

Yes, VLOOKUP is a powerful tool but most of excel's other lookup functions are also useful.  It can be very helpful to make one lookup fuction an argument of a second fuction (use Match to find the row or column of a chart which in tern is an argument of Index).

I recommend Excel for Scientists and Engineers by William J. Orvis
You can see the entire index at; http://www.amazon.com/exec/obidos/tg/detail/-/0782117619/ref=pd_sim_books_2/104-7191529-1272727?v=glance&s=books

RE: Vlookup function

Another interesting function that does something similar is the offest command. I use this for dealing with information inputted from drop down menus built using the forms options.

RE: Vlookup function

Should of course have been OFFSET - Typo demon strikes again...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close