Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel not recognizing equal values
I can't get my vlookup formula to recognize an equal value in another column
unless I double-click on the cell that contains the value that I'm looking for in the other column. For one or two cells, that's not a big deal, but for a few hundred cells at a time... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel not recognizing equal values
The cells you are double-clicking probably are text values that look like
numbers. Try copying a single blank cell, selecting all the values in that column, then using Edit-Paste Special-VAlues-Add "san-avsc" wrote: I can't get my vlookup formula to recognize an equal value in another column unless I double-click on the cell that contains the value that I'm looking for in the other column. For one or two cells, that's not a big deal, but for a few hundred cells at a time... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel not recognizing equal values
How do I Paste SpecialValuesADD? I mean, how do I do the "adding" (and why)?
If I copy a blank cell, and paste the value into the lookup column, it just empties out the column. "Duke Carey" wrote: The cells you are double-clicking probably are text values that look like numbers. Try copying a single blank cell, selecting all the values in that column, then using Edit-Paste Special-VAlues-Add "san-avsc" wrote: I can't get my vlookup formula to recognize an equal value in another column unless I double-click on the cell that contains the value that I'm looking for in the other column. For one or two cells, that's not a big deal, but for a few hundred cells at a time... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel not recognizing equal values
by the way, I've tried changing the format of the cells every which way -
from text to numbers, from numbers back to text, both in the lookup values and in the range, but still it's still not working. "Duke Carey" wrote: The cells you are double-clicking probably are text values that look like numbers. Try copying a single blank cell, selecting all the values in that column, then using Edit-Paste Special-VAlues-Add "san-avsc" wrote: I can't get my vlookup formula to recognize an equal value in another column unless I double-click on the cell that contains the value that I'm looking for in the other column. For one or two cells, that's not a big deal, but for a few hundred cells at a time... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel not recognizing equal values
In the Paste Special dialog box there is an option to Add what you have
copied to the selected cells. Since you've copied 'nothing', that is what gets added. If forces Excel to convert the values from text to numbers. You ought to make sure that the column is formatted as general before performing this operation. "san-avsc" wrote: How do I Paste SpecialValuesADD? I mean, how do I do the "adding" (and why)? If I copy a blank cell, and paste the value into the lookup column, it just empties out the column. "Duke Carey" wrote: The cells you are double-clicking probably are text values that look like numbers. Try copying a single blank cell, selecting all the values in that column, then using Edit-Paste Special-VAlues-Add "san-avsc" wrote: I can't get my vlookup formula to recognize an equal value in another column unless I double-click on the cell that contains the value that I'm looking for in the other column. For one or two cells, that's not a big deal, but for a few hundred cells at a time... |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel not recognizing equal values
This worked perfectly - thanks a lot.
"Duke Carey" wrote: In the Paste Special dialog box there is an option to Add what you have copied to the selected cells. Since you've copied 'nothing', that is what gets added. If forces Excel to convert the values from text to numbers. You ought to make sure that the column is formatted as general before performing this operation. "san-avsc" wrote: How do I Paste SpecialValuesADD? I mean, how do I do the "adding" (and why)? If I copy a blank cell, and paste the value into the lookup column, it just empties out the column. "Duke Carey" wrote: The cells you are double-clicking probably are text values that look like numbers. Try copying a single blank cell, selecting all the values in that column, then using Edit-Paste Special-VAlues-Add "san-avsc" wrote: I can't get my vlookup formula to recognize an equal value in another column unless I double-click on the cell that contains the value that I'm looking for in the other column. For one or two cells, that's not a big deal, but for a few hundred cells at a time... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
recording more than 2 changing values in Excel at a time??? | Excel Worksheet Functions | |||
How to be noticed/to avoid equal values in a colum | Excel Worksheet Functions | |||
Unwanted Zeros in Excel Chart Displayed Values | Excel Discussion (Misc queries) | |||
excel storing previous cell values in memory | Excel Worksheet Functions | |||
How do I sum rounded values from two seperate formulas in Excel? | Excel Worksheet Functions |