D3:
Formula:
=MATCH($C3,J$4:J$8,1)
and copy down/right
PS. I originally thought about more complicated one. say in I9:L10 you have:
Base (upg1) 100 300 500
Each UP+ 100 200 300
then in D3:
Formula:
=MIN(ROUNDDOWN(($C3-J$9)/J$10,0)+1,5)
would return the same results. But first approach is by far better
(I left original concept for reference in last few rows of the table, so you could compare results)
if upgrades are not just numbered but have some specyfic names in I4:I8 then formula for D3 would be:
Formula:
=INDEX($I$4:$I$8,MATCH($C3,J$4:J$8,1))
Bookmarks