if cell a gets this value then cell b receives this value: how to

S

static69

the point scale is 300 points. the value in column b is on a 100 point
scale. If they do not reach 180 points on the eval, then they receive
an unstisfactory rating. 180 is 70 points. every point there after in
the evaluation reaises the value in column b by .25. 181=70.25
182=70.50 this continues on until the max of 300 eval points for a
100% rating in column B. Does that help?
 
L

Lynxbci3

Surely you just need to therefore lookup the appropriate value

=vlookup(A,sheet!(a:b),2,false)

A is the value on the main sheet
sheet is the sheet where the list is held
a:b is the column range of the lookup (always use colums if you can)
2 is the valuye you are retrieving
False will eman you only get exact matches, you don't need thi
especiall
 
F

Frank Kabel

Hi
this formula would raise a syntax error. you probably meant:
=vlookup(A,sheet!a:b,2,false)

Also I wouldn'tn second your recommendation to always use columns. This
could slow down your spreadsheet if you use several of these formulas
 
Top