"...For the mention case, i think its too complicated and should leave it as we update it manually as before, ..."
Maybe my example was not very clear to solve your doubt.
The issue is not complicated.
It is very simple and classic in the Excel world.
I gave you an example with a function prepared exclusively for this type of case.
You may want to resolve this using another function.
Maybe a nested IF function.
You can ask the questions you want about it.
The idea is to help you solve your problem at work.
You can count on us.
You can save your excel files to any free sites, www.sendspace.com or ge.tt or www.dropbox.com and put the link to download the files here.
This way we can help you directly in your work files.
Belo Horizonte, Brasil.
If you want to find the exact value in the table, the data to the left can be placed in any order.
The function will find the data and show the corresponding data in the column that you indicate.
To do this, just put the word FALSE in the last parameter of the function.
If you want to search for a data that is in ranges of values, then the data in the left column should be sorted in ascending order.
The function will look for the data as the value searched is smaller or equal to the nearest and will show the corresponding data in the column that you indicate.
To do this, just put the word TRUE in the last parameter of the function.
This is the exact case of your doubt.