Hi,

I have a column filled with a formula that produces a numerical value. If this numerical value is greater than a certain value I want to grab the value in the column next to it on the same row.

Example:

A | B

A 6
B 7
C 9
D 11
E 12

So, in a new cell in col C I need a formula to check if a value in col B is either equal to or greater than 10 and then grab the value from col A. So in this example the output would be 'D'.

Thanks for the help.