| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing a Rounded number in a LOOKUP command
Hello,
I have a cell that is rounding up another cell. Let's call that cell A1. I have another cell that is looking up the rounded cell, A1, but it is not outputting the correct number from the referenced table. The look-up array and output array are both correct. I tested this same command in a separate file and it works just fine. Also, when I simply input an actual number in cell A1, my lookup command works fine. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Referencing a Rounded number in a LOOKUP command
=VLOOKUP(A1, C:D,2, False)
If D has numbers before rounding then use A1 without rounding, "sCOTT" wrote: Hello, I have a cell that is rounding up another cell. Let's call that cell A1. I have another cell that is looking up the rounded cell, A1, but it is not outputting the correct number from the referenced table. The look-up array and output array are both correct. I tested this same command in a separate file and it works just fine. Also, when I simply input an actual number in cell A1, my lookup command works fine. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Number Formats - Billion Dollars Rounded | Excel Worksheet Functions | |||
| how to display rounded number in a cell w/formula | Excel Discussion (Misc queries) | |||
| Number are rounded to thousand, but they now do not foot | Excel Discussion (Misc queries) | |||
| marrying a rounded number to concatenation. | New Users to Excel | |||
| Can you get around the GETPIVOTDATA command when referencing a pi. | Excel Worksheet Functions | |||
Linear Mode
