How can I convert the following formulas into VBA?
=IF(ISBLANK(C2),"",VLOOKUP(C2,Inventory!$A$2:D37812,3,FALSE))
=IF(ISBLANK(C2),"",VLOOKUP(C2,Inventory!$A$2:D37812,4,FALSE))
=IF(ISBLANK(C2),"",VLOOKUP(C2,Inventory!$A$2:D37812,2,FALSE))
=IF(C3="","",A2)
Each one needs to go down the entire range of rows. Sample spreadsheet is attached.
The basic construct for one formula is
To get the coding for the other formulas, turn on the macro recorder, put the cursor in E2 >> hit F2 >> tab
Please Login or Register to view this content.
Repeat this process for the other cells.
HTH
Regards, Jeff
I kind of understand what you mean, but not all the way. I tried what you said, but it did not work. Can you explain a little more please?
Before you begin, make sure you lock the table reference which means placing the dollar signs around the column and row.
The formula in E2 should look like this
In D2, E2, and F2 you have formulas. Put your cursor in D2 >> Developer tab on ribbon >> Record MacroPlease Login or Register to view this content.
Now place your cursor in the formula bar or select the F2 key which does the same thing.
Hit the tab key which will place your cursor now in E2 and repeat the steps above.
Hit the tab key again and now you are in F2 and repeat.
Open up the VBE >> Alt + F11
All the recorded formulas are now in a module
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks