View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stee n Stee n is offline
external usenet poster
 
Posts: 6
Default Problem using vlookup to get values from another file

Hi

I try to use vlookup to get values from another worksheet, but do not get
the expected values.

Formula used in Col I, Row 1319:
=VLOOKUP(F1319;[V60VMPParameterSettingsLAC_STMLA.xls]V60ParaSettingsLACControl!$A:$D;1;TRUE)

Ex. of Excel file where formular is used - row1318-1320.
A B C E F
G...
Thyristors ThyGx 8 82 THYIntervalAngle40Px Reserved In Delta Phi
Int5 0
Pitch PitchGx 9 1 TsScanPx msec TsScanPx
100 LowGridVoltStartPx
Pitch PitchGx 9 2 PitchNoLoadAboveRpmPx RPM Pitch to NoLoad above
RPM 1500

Data Excel file:
Sheet 1 : General
A B C D E F
G
TsScanPx msec TsScanPx 100 100 100 100
MaxPowerRefVelPx kW/s Max power ref up vel. 100 100 100 100
MaxPowerRefDownVelPx kW/s Max power ref down vel. 100 100 100 100

The problem is that I dont get the value 100 as expected, but insted a value
999!

Any help?