lookup and compare

  • Thread starter Thread starter AndyLee
  • Start date Start date
A

AndyLee

hi, i want to insert a lenght into a cell and have another cell display a
size required based on a size range: say lenght 138cm gives size2 100-149cm

input cell output cell
Lenght: 138cm you require a: size2

A B C
1 size1 50 99
2 size2 100 149
3 size3 150 199
4 size4 200 249
 
set up your table

0 too small
50 size1
100 size2
150 size3
200 size4
250 too large

and use the formula
=VLOOKUP(L1,M1:N6,2,TRUE)
where the table sits in M1:L6
L1 is the cell you enter the length
2 is the second column of the table
TRUE will cause to look to the nearest

greetings from New Zealand in 2010
 
Normally, in such cases, you may omit the TRUE because this is the default.
"Happy new year" [it is exactly midnight here].
Micky
 
Back
Top