Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Vlookup Formula to Macro
Hello
I have the following Formula that I have pasted into each Cell down in Column C, so when a Part Number is entered into a Cell in Column A, the correct Part Description for that Part Number is then looked up in the PARTNUMBERS worksheet, and the correct Part Description is then automatically put into the cell in Column C. =IF($A2="","",VLOOKUP($A2,PARTNUMBERS!$A$2:$B$1000 ,2,FALSE)) I found this Formula on a newsgroup and edited it to suit my worksheet so it probably could be fine tuned further to suit my needs but it works ok. What I would like to do is to convert this Formula into a Macro. Can anyone help. Cheers Ian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert text to formula using VLookup | Excel Worksheet Functions | |||
convert vlookup formula to link formula | Excel Worksheet Functions | |||
Excel 2002: Can I convert #N/A to 0 in the VLOOKUP( ) formula ? | Excel Discussion (Misc queries) | |||
MACRO: Convert Row Formula to Value | Excel Discussion (Misc queries) | |||
convert a formula into a macro | Excel Discussion (Misc queries) |