excell formula needed

  • Thread starter Thread starter terrificRob
  • Start date Start date
T

terrificRob

Hi,
In Excell, I'm trying to match a cell (eg H21,with a num value (eg
2530) to a column of figures (M34:M99) that has one match in it and
produce a grading A, B, C, D from a column (N34:N99). Anyone have any
ideas?
Rob.
 
terrificRob said:
Hi,
In Excell, I'm trying to match a cell (eg H21,with a num value (eg
2530) to a column of figures (M34:M99) that has one match in it and
produce a grading A, B, C, D from a column (N34:N99). Anyone have any
ideas?
Rob.
Click to expand...

Try this:
=VLOOKUP(H21,M34:N99,2,0)
 
Back
Top