Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup
Can you help me, why this script doesn't work?
I ahve two sheets with names in different order. I want to get value from col E for a certain name (names are in col C) in sheet "hodiny" and paste it next to the same name (names are in col D) in sheet "list" in col I. I tried to use the script I post here, but it causes an error message Thank you Milos Sub hodiny_sep() Dim res As Long Dim i As Long i = 3 Do While Sheets("List").Range("D" & i).Value < "" res = Application.VLookup(Sheets("List").Range("D" & i), Sheets("hodiny").Range("C2:C200"), 7, False) Sheets("List").Range("I" & i).Value = Sheets("hodiny").Range("E" & res).Value x = x + 1 Loop End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Which is faster: VLOOKUP-worksheet or VB-array VLOOKUP? | Excel Programming | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel |