So I am trying to make a calculator. The calculator will output values based on a formula depending on what column the input is found in....I have 3 different columns, all with email addresses in them. The idea is you plug in your email address, it looks up your email and finds it in column A, B or C. Then based on that it will do a few sumifs, among other things, depending on which column you are in (the calculation changes per column)

How can I do this? Also, a more basic question: how can I reference worksheets in VBA? (the vba would be in sheet 2, while the data it looks up, and sums etc is in sheet 1).

I hope this is specific enough, I do not have any code to start us off, mainly because I do not know where to start, and do not want to limit myself with poorly constructed code.

Also, I'm told this can be done without VBA, using some little known built in function...but idk what it is, so I can't look up how to use it...VBA or built in function- whichever gets the job done!

Thanks