| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VLOOKUP with VB
Hi,
I have the current code and would like help with two queestions: 1) is it possible to return the value and not the formula 2) Is it possible to enter the formula in all the cells without using copy down 'Copy EIF Numbers to NB sheet Sheets("NB").Range("P3") = "EIF" Sheets("NB").Range("O3").Copy Sheets("NB").Range("P3").PasteSpecial Paste:=xlPasteFormats Sheets("NB").Range("P4").FormulaR1C1 = "=VLOOKUP(NB!RC[-15]&RC[-14],EIF!C[-15]:C[-9],7,FALSE)" LastRow = Sheets("NB").Range("D" & Rows.Count).End(xlUp).Row Sheets("NB").Range("P4").Copy _ Destination:=Sheets("NB").Range("P5:P" & (LastRow)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup problem - unable to get the vlookup property | Excel Programming | |||
| using a vlookup to enter text into rows beneath the vlookup cell | Excel Programming | |||
| 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 | |||
Threaded Mode
