Custom functions?

[JimmyDodger]

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

 

[JimmyDodger]

You are right, i had to change the range to A:C before it worked...