Hello,

I would like to learn how to make an equation that will automatically pull numbers from a column based on what number I put in one cell.

What equation would one use for that kind of function?

I have numbers listed in Columns A, B and C, and a function Y = (([Cell B1]*4 + [Cell C1])*0.02)/4

And in Column A I have every integer ranging from 60 to 100. In Columns B and C I have numbers.

So my goal here is to make a function that, if I enter 60 in this cell, the function will match that number in Column A and pull results from B and C in same row to put in that function.

How do I do that? IF/THEN or MATCH or...? I'm not really sure how.