Problem using vlookup to get values from another file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stee n - 28 May 2008 12:23 GMT

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?

Reply to this Message

Jim Cone - 28 May 2008 14:22 GMT

Your data layout came thru all muddled up.
However, in a VLookUp formula, if the last argument is True then the
data in Column 1 must be in ascending order.
Try 0 as the last argument and see what happens.

Signature

Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Stee n" <Steen@discussions.microsoft.com>
wrote in message
Hi
I try to use vlookup to get values from another worksheet, but do not get
the expected values.
-snip-
The problem is that I dont get the value 100 as expected, but insted a value 999!
Any help?

Reply to this Message