| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup does not work -copy info from the above cell
Hi,
Please help. When this function does not find the value on the table it puts the information from the above cell instead of leaving blank or error: I sheet 1, column A I a have 663 values and I am trying to see if those values are in Sheet 2, I have 670 values, I am trying to see which one are not in Sheet A. Please help. Maybe I am using the wrong function. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup does not work -copy info from the above cell
You should be using Vlookup(), with the 4th argument set to 0, or FALSE.
-- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Mary" wrote in message ... Hi, Please help. When this function does not find the value on the table it puts the information from the above cell instead of leaving blank or error: I sheet 1, column A I a have 663 values and I am trying to see if those values are in Sheet 2, I have 670 values, I am trying to see which one are not in Sheet A. Please help. Maybe I am using the wrong function. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lookup does not work -copy info from the above cell
On Apr 13, 4:34 pm, Mary wrote:
Hi, Please help. When this function does not find the value on the table it puts the information from the above cell instead of leaving blank or error: I sheet 1, column A I a have 663 values and I am trying to see if those values are in Sheet 2, I have 670 values, I am trying to see which one are not in Sheet A. Please help. Maybe I am using the wrong function. Not sure which function you are using, but MATCH(lookup_value,lookup_array,0) should return an exact match, or an N/A value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to skip to next cell to lookup info until found | Excel Worksheet Functions | |||
| Copy Info from cell to another sheet | Excel Discussion (Misc queries) | |||
| HOW DO I COPY & PASTE A SMALL INFO FM AN XL TO THE CELL COMMENT | Excel Worksheet Functions | |||
| Copy and insert cell info macro help | Excel Discussion (Misc queries) | |||
| comparing a column of cell and then copy info to other cells | Excel Discussion (Misc queries) | |||
Linear Mode
