A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 0-9 !@$* active | api | Application | array | chart | clipboard | color | date and time | debug | Error | file | filter | find | format | log | loop | named range | PPT | Pivot Table | record | udf | workbook | wrapper Continue at Database_code 948 Steps to 6 Figures by Learning Excel-VBA and Other Skills |
| • | =vlookup (xl func) | |
| • | vlookup to external file - '[file name.xlsm]sheetname'!$C:$F | |
| • | application.evaluate(sLookup) - runs a vlookup or match or other excel statemnt | |
| • | VLookup with RC[-44] from recorded code | |
| • | Application.Evaluate("=vlookup(""" & ..... & """,'" & from .... | |
| • | =Ifna(vlookup(... | |
| • | =IfERROR(VLOOKUP(INDIRECT(ADDRESS(ROW(),VLOOKUP($BW2,'Field To Use'!$H:$O,6,0))),'Rating Lookup'!$A:$B,2,0),0) | |
| • | VLookup as part of a formula with """ multiple quotes issue | |
| • | 11/12/14 Random XL, vlookup |