Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP
Hi, Im using a vba code for what could be done by vlookup, but I need the
code not the function. The code below is what I am using. Sub Help() For Each ce In Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row) If WorksheetFunction.CountIf(Range("b:b"), ce.Value) Then ce.Offset(0, 13).Value = Cells(ce.Row, 3) Else ce.Offset(0, 100).Value = "" End If *My Data looks like this. When i run the program the answer im getting for 2217 is 465, but the correct answer is 414. Same with 2540. The answer thats correct for 2540 is 465, but im getting 332. Any ideas? Col A Col B Col C 2265 2265 332 2540 2265 332 2217 2540 465 2217 414 Next ce End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP
try:
ce.Offset(0, 13).Value = Cells(ce.Row - 1, 3) "Busybee" skrev: Hi, Im using a vba code for what could be done by vlookup, but I need the code not the function. The code below is what I am using. Sub Help() For Each ce In Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row) If WorksheetFunction.CountIf(Range("b:b"), ce.Value) Then ce.Offset(0, 13).Value = Cells(ce.Row, 3) Else ce.Offset(0, 100).Value = "" End If *My Data looks like this. When i run the program the answer im getting for 2217 is 465, but the correct answer is 414. Same with 2540. The answer thats correct for 2540 is 465, but im getting 332. Any ideas? Col A Col B Col C 2265 2265 332 2540 2265 332 2217 2540 465 2217 414 Next ce End Sub |
Reply |
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) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |