VLOOKUP gets wrong value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stee n - 28 May 2008 13:48 GMT

Hi
I have a problem using VLOOKUP - I dont get the expected result:

Using the following VLOOKUP: =VLOOKUP(C1;A1:B49;2) give me 700 instead of
the expected 100. Any help on that issue?

A B C
TsScanPx    100 MaxPowerRefVelPx
MaxPowerRefVelPx    100
MaxPowerRefDownVelPx    100
NomGen1SpeedPx    1500
GeneratorSelectPx    0
PowerNominelPx    850
G1ConnectRPMPx    1450
G1MinStaticRPMPx    1250
G1PowerRefMaxPx    850
G1PowerRefMinPx    -50
G1PowerTimeConstPx    20
Gen1PowerMinPx    100
G1PowerMinInitTimePx    10
G1PowerMinStableTimePx    40
Gen1PowerMaxPx    850
G1PowerMaxInitTimePx    10
G1PowerMaxStableTimePx    5
G2ConnectRPMPx    1250
G2MinStaticRPMPx    900
G2MinRPMPx    1000
G2PowerRefMaxPx    450
G2PowerRefMinPx    -50
G2PowerTimeConstPx    20
Gen2PowerMinPx    0
G2PowerMinInitTimePx    10
G2PowerMinStableTimePx    10
Gen2PowerMaxPx    400
G2PowerMaxInitTimePx    10
G2PowerMaxStableTimePx    30
LowVoltConnectLimPx    700
NomTorqRPMPx    1620
MaxStaticPRotorPx    65
PowerStatorMaxPx    830
G1MinConnectSpeedPx    1200
G2MinConnectSpeedPx    1000
PitchServoGainNegativePx    250
PitchServoGainPositivePx    300
DeadZoneGainPx    1200
DeadZonePx    3000
DeadZoneOffsetPx    0
PitchServoGainNegPartLoadPx    250
PitchServoGainPosPartLoadPx    300
DeadZoneGainPartLoadPx    0
DeadZonePartLoadPx    0
DeadZoneOffsetPartLoadPx    0
LAPosControllerKpPx    323
LAPosControllerTiPx    10000
LAPosControllerTauPx    500
LAPosCtrlActivePitchPosPx    800

Reply to this Message

Janusz Pawlinka - 28 May 2008 14:02 GMT

add fourth (optional) argument in function VLOOKUP

=VLOOKUP(C1;A1:B49;2;FALSE)

--
Janusz Pawlinka

Reply to this Message

nsv - 28 May 2008 14:07 GMT

The block, in which you search, must be sorted by ascending col A

NSV

> Hi
> I have a problem using VLOOKUP - I dont get the expected result:
[quoted text clipped - 54 lines]
>
>

Reply to this Message

Stee n - 28 May 2008 14:27 GMT

Hi NSV and Janusz

Thanks for your quick answer - both are working fine :-)

> The block, in which you search, must be sorted by ascending col A
>
[quoted text clipped - 58 lines]
> >
> >

Reply to this Message

Dave Peterson - 28 May 2008 14:25 GMT

Since you're matching on a string, I bet you want an exact match:

=VLOOKUP(C1;A1:B49;2;False)

> Hi
> I have a problem using VLOOKUP - I dont get the expected result:
[quoted text clipped - 52 lines]
> LAPosControllerTauPx 500
> LAPosCtrlActivePitchPosPx 800

Signature

Dave Peterson

Reply to this Message