How to use vlookup for rounding up numbers in Excel 2003
I'm using Excel 2003 on my system. I would like to know that how can i use vlookup for rounding up a particular number in my excel sheet. It should be round up to its nearest number. Can any body tell me that how can i do it? Does any body have any idea about it? Kindly provide me the correct sloution for the above issue. Any kind of information on the above issue would be appreciated.
Re: How to use vlookup for rounding up numbers in Excel 2003
In Excel you can easily round number in order to view it. You can do it by just going to FormatMenu and then select Cells Numberand then need to select Number under Category. Then you can create a short cut by using the Increase Decimals and Decrease Decimals on the Format toolbar, which you can see it at the right of $ %, symbols.
Re: How to use vlookup for rounding up numbers in Excel 2003
You can also use the following:-
The HLOOKUP function uses the following syntax:
Quote:
=HLOOKUP(lookup_value,table_array,row_index_num,[range_lookup])
The VLOOKUP function follows the nearly identical syntax:
Quote:
=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]
In both functions, the lookup_value argument is the value that you want to look up in the table, table_array is the cell range or name of the table that contains both the value to look up and the related value to return.
Re: How to use vlookup for rounding up numbers in Excel 2003
Use the TRUNC function in your VLOOKUP or HLOOKUP function to force the LOOKUP value to be evaluated to a specific number of decimal places. For example, type the VLOOKUP function as follows:
Quote:
=VLOOKUP(TRUNC(A1,2),C1: D5,2,FALSE)
This formula rounds the LOOKUP value in cell A1 to two decimal places and then looks for it in the lookup table (C1: D5). The formula returns the data from the second column of the lookup table. You can also check out the following link. Hope so it may help you out.