VLOOKUP gets wrong value

[Stee n]

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

 

[nsv]

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

NSV

 

[Dave Peterson]

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

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

 

[Stee n]

Hi NSV and Janusz

Thanks for your quick answer - both are working fine