vlookup & hlookup

[Michele]

I understand the concept on how to use these two functions, but I do not understand why you would write a formula for results that you can see on the data table? What am I not getting?

 

[Max]

Well, think the 2 lookups (vlookup, hlookup) does
enable an "automatic" way for one to look-up
& pluck out relevant data from the "data table"
corresponding to values in another column for viewing,
or for further use in downstream calculations.

The look-up tables could also be huge and you may also
be having to look-up a large number of values repetitiously
(e.g.: look-up 50,000 values placed in A2:A50001)

It would be *mind boggling* to have to do this manually,
in an error free manner, and in a couple of seconds <g>!

--
Rgds
Max
xl 97
----------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------

I understand the concept on how to use these two functions, but I do not

understand why you would write a formula for results that you can see on the
data table? What am I not getting?

 

[Michele]

Thanks for your time, Max

 

[Max]

you're welcome, Michele !