Re: vlookup problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Nel post news:terryc.2a2k84_1151425811.4766@xxxxxxxxxxxxxxxxxxxxx
*terryc* ha scritto:

I have tried using a Pivot Table, but it isn't really helping.

I need the user to be able to type in an age, and then the table I've
described should be automatically generated.

The data will also be automatically graphed on another work***.

Does anyone else have any ideas how I could get around the problem of
VLookup only returning the first value it finds?

With a Pivot Table your user instead of typing an age should just (in a very
simple manner) select it from a drop down list...




--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy


.


Quantcast