what are the uses for Vlookup and Hlookup?

[Guest]

I need to know what are some of the uses for Vlookup and Hlookup functions.
When they would be useful and the easiest way to use them.

 

[Biff]

There's an example here:

http://contextures.com/xlFunctions02.html

Try it out and you'll see how useful it can be!

Biff

 

[BlueDaze]

You should also get real comfortable with the Index function, and yo
can nest the match function within it to assign row and column numbers
That's sort of like combining vlookup and hlookup into one