Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 06-06-2009
Member
 
Join Date: Apr 2009
Posts: 91
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.
Reply With Quote
  #2  
Old 06-06-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
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.
Reply With Quote
  #3  
Old 06-06-2009
Member
 
Join Date: May 2008
Posts: 4,565
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.
Reply With Quote
  #4  
Old 06-06-2009
Member
 
Join Date: May 2008
Posts: 4,339
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to use vlookup for rounding up numbers in Excel 2003"
Thread Thread Starter Forum Replies Last Post
Need help to get rid of #n/a error in Excel Vlookup Culpritism MS Office Support 2 24-02-2012 07:39 PM
How to make Microsoft Excel to stop rounding out 16 digit number Talisha MS Office Support 2 01-02-2012 07:10 PM
How to get yes or no in Vlookup in Excel Gurmeet MS Office Support 2 24-01-2012 04:57 PM
How to change negative numbers to positive numbers in Excel Shaina Na Microsoft Project 3 08-01-2012 05:35 PM
How to convert fractional inches into rounding numbers Rock Villa Software Development 2 01-07-2009 12:54 PM


All times are GMT +5.5. The time now is 03:11 AM.