Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem using vlookup to get values from another file
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. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Stee n" 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using vlookup to get values from another excel file | Excel Discussion (Misc queries) | |||
How to tell number of spaces between values in saved text file fromthe original xls file | Excel Discussion (Misc queries) | |||
Variabilize File Path or File Name in SumProduct (and Vlookup too) | Excel Worksheet Functions | |||
How do I convert an excel file into a comma separated values file | Excel Discussion (Misc queries) | |||
vlookup, multiple values, sum values into one cell?? | Excel Worksheet Functions |