Hi I need Excel sheet function to find Number from "XX" column and get result from Right Second column "YY" if has decimal such 0.5, 0.7 go through below Table and get Result from right Column
get the intger Number 2212 then find 3 in Small Table
Plus 0.5
get the intger Number 2212 then find 3 in Small Table
Book1 | ||||
---|---|---|---|---|
A | B | |||
10 | 1.8 | 2212.3 | ||
Sheet1 |
Plus 0.5
Book1 | ||||
---|---|---|---|---|
C | D | |||
27 | 3 | 0.5 | ||
Sheet1 |