Hi everyone!!
Down below I have a list and the problem is this: I want to generate items from the list when a precise value like: 875 X 1150 or 1478 X 3620 is entered in a cell . Let say, someone has entered : 875 X 1150 or 1478 X 3620 in (column A) and I want in (column B) the rounded value from the list to show ! Is it possible to do this with excel? or need the VBA? Or what is my best option (tools) to get result like this? Ohhh by the way I am using excel 2007 and I am brand new at it!hehehe!!
Thank you All in advance!!
<tbody>
</tbody>
<tbody>
</tbody>
Down below I have a list and the problem is this: I want to generate items from the list when a precise value like: 875 X 1150 or 1478 X 3620 is entered in a cell . Let say, someone has entered : 875 X 1150 or 1478 X 3620 in (column A) and I want in (column B) the rounded value from the list to show ! Is it possible to do this with excel? or need the VBA? Or what is my best option (tools) to get result like this? Ohhh by the way I am using excel 2007 and I am brand new at it!hehehe!!
Thank you All in advance!!
real value order | rounded value from list |
875 X 1150 | 900 X 1200 |
1478 X 3620 | 1500 X 3600 |
| |
| |
List below | |
<tbody>
</tbody>
900 X 300 | 1200 X 300 | 1500 X 300 | 1800 X 300 | 2400 X 300 |
900 X 600 | 1200 X 600 | 1500 X 600 | 1800 X 600 | 2400 X 600 |
900 X 900 | 1200 X 900 | 1500 X 900 | 1800 X 900 | 2400 X 900 |
900 X 1200 | 1200 X 1200 | 1500 X 1200 | 1800 X 1200 | 2400 X 1200 |
900 X 1500 | 1200 X 1500 | 1500 X 1500 | 1800 X 1500 | 2400 X 1500 |
900 X 1800 | 1200 X 1800 | 1500 X 1800 | 1800 X 1800 | 2400 X 1800 |
900 X 2100 | 1200 X 2100 | 1500 X 2100 | 1800 X 2100 | 2400 X 2100 |
900 X 2400 | 1200 X 2400 | 1500 X 2400 | 1800 X 2400 | 2400 X 2400 |
900 X 2700 | 1200 X 2700 | 1500 X 2700 | 1800 X 2700 | 2400 X 2700 |
900 X 3000 | 1200 X 3000 | 1500 X 3000 | 1800 X 3000 | 2400 X 3000 |
900 X 3300 | 1200 X 3300 | 1500 X 3300 | 1800 X 3300 | 2400 X 3300 |
900 X 3600 | 1200 X 3600 | 1500 X 3600 | 1800 X 3600 | 2400 X 3600 |
900 X 3900 | 1200 X 3900 | 1500 X 3900 | 1800 X 3900 | 2400 X 3900 |
900 X 4200 | 1200 X 4200 | 1500 X 4200 | 1800 X 4200 | 2400 X 4200 |
<tbody>
</tbody>