JimmyDodger
Board Regular
- Joined
- May 3, 2007
- Messages
- 159
Hi,
Is there a way of making a complex formula into a custom function?
Basically I'm going to have to type out the following about 500 times.
=vlookup(A2,Data!A:B,2,false)
where A2 is going to change, this could be any cell.
I want to be able to type out a number of calculations without having to enter the full formula each time. I'm going to have to do about 500 of them and they wille ach be different
eg =custom(A2)+custom(A7)/custom(d5)
=custom(B4)/100
Is there a way of making a complex formula into a custom function?
Basically I'm going to have to type out the following about 500 times.
=vlookup(A2,Data!A:B,2,false)
where A2 is going to change, this could be any cell.
I want to be able to type out a number of calculations without having to enter the full formula each time. I'm going to have to do about 500 of them and they wille ach be different
eg =custom(A2)+custom(A7)/custom(d5)
=custom(B4)/100