hi,
I want to build a macro that scans across a range of cells (eg. B3:D3), finds which cell =1 (there is only one piece of data in each range) , then depending on which column it is in performs a calculation on it. then drops to the next row and repeats.
row 2 contains the time period.
In my sheet (in row 3 for example) column A is the input data, B is calculated from the equation =1-exp(-1*A3*$B$2), C is calculated by the equation =(A2/2)*$C$2, D is calculated by the equation=(A2/2)*$D$2.
A previous macro makes the individual values =1, then i want to add this step to automatically return them to the original.
this is a very simplified version of a complex worksheet.
I assume this is going to use vlookup's and nested if statements but cant seem to make it function.
Thanks for your help.example vlookups.xlsx
Bookmarks