Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > VLOOKUP gets wrong value
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 6
Default VLOOKUP gets wrong value
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 With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 17
Default VLOOKUP gets wrong value

add fourth (optional) argument in function VLOOKUP

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

--
Janusz Pawlinka


Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 1
Default VLOOKUP gets wrong value
The block, in which you search, must be sorted by ascending col A

NSV


"Stee n" wrote:

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 With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 35,218
Default VLOOKUP gets wrong value
Since you're matching on a string, I bet you want an exact match:

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



Stee n wrote:

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



--

Dave Peterson
Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 6
Default VLOOKUP gets wrong value
Hi NSV and Janusz

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

"nsv" wrote:

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

NSV


"Stee n" wrote:

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 With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup-Wrong Sheet! BB New Users to Excel 9 August 5th 07 10:57 PM
Vlookup - can't figure out what's wrong pm Excel Worksheet Functions 5 December 15th 06 08:02 PM
vlookup, what am I doing wrong? ufo_pilot Excel Discussion (Misc queries) 3 August 9th 05 05:36 PM
VLOOKUP returning wrong row jthomas Excel Worksheet Functions 6 August 3rd 05 10:32 PM
What wrong with VLOOKUP formula TARZAN Excel Worksheet Functions 2 January 31st 05 10:09 PM


All times are GMT +1. The time now is 08:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement