what are the uses for Vlookup and Hlookup?
 

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.

what are the uses for Vlookup and Hlookup?
 

There's an example he

http://contextures.com/xlFunctions02.html

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

Biff

"aeroluv" wrote in message
...
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.

what are the uses for Vlookup and Hlookup?
 

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


--
BlueDaze


------------------------------------------------------------------------
BlueDaze's Profile: http://www.excelforum.com/member.php...o&userid=27465
View this thread: http://www.excelforum.com/showthread...hreadid=569290