| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing "IF" or "Lookup" formulas with VBA function
In worksheet1 I have a range (a1:b12).
In worksheet2 I have 12 column headings (a1:l1) and I want to search worksheet1 range a1:a12 for the corresponding column headings then populate worksheet2(a2:l2) with the data from worksheet1 (b1:b12). I was able to use the "IF" formula in worksheet2 until I expanded past the 7 nested functions rule. I've tried to use Lookup and Vlookup formulas but both require sorting which is not an option. I've also tried to use the IFELSE function and LOOKUP functions in VBA without success. I appreciate the assistance and enjoy the learnings that go into problem solving. Thanks, dhunter43 The Performance Advantage, LLC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
