Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looking up a value and returning another
Have a value in one sheet (obtained by importing a text file) and want to
look up the value (value will start in C7 and continue down column C) in another workbook (B6:B2000). Once I find that value I then need to return a value 2 columns over in the same row (D6:D2000). Here is what I have: DataFileName = Application.GetOpenFilename(fileFilter:="Text or ASC Files, *.txt; *.asc", Title:="Select the Data File") Open DataFileName For Input As #FileNum VMM_FileName = Application.GetOpenFilename(fileFilter:="DBF Files, *.dbf", Title:="Select the VMM File") Workbooks.OpenText Filename:=VMM_FileName VMM_Workbook = ActiveWorkbook Workbooks.Add template:=xlWorksheet Set Data_Workbook = ActiveWorkbook .... code here for importing text file Have tried Match, Find, Index, ... can not get any to work. Need help to find the answer. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UDF from Add-In returning #NAME | Excel Worksheet Functions | |||
Returning #N/A | Excel Discussion (Misc queries) | |||
Sum returning 0 | Excel Worksheet Functions | |||
UDF returning #VALUE! why? | Excel Discussion (Misc queries) | |||
If/Then help in returning value | Excel Programming |