| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
matching like numbers/data points residing in different columns
So you're saying: you want blanks in col B if they don't appear in co A? In B1, put the formula =VLOOKUP($B1,$A:$A,1,0) then fill down in col B to the bottom and replace all #N?A in col with blanks Co -- colofnatur ----------------------------------------------------------------------- colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435 View this thread: http://www.excelforum.com/showthread.php?threadid=57197 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Format numbers from percentage points to basis points | Excel Discussion (Misc queries) | |||
| Returning a value in excel my matching 2 data points | Excel Discussion (Misc queries) | |||
| Verifying and moving non matching numbers in columns | Excel Worksheet Functions | |||
| How to create reports based on data residing in multiple workbooks | Excel Discussion (Misc queries) | |||
| Matching data in columns | Excel Discussion (Misc queries) | |||
![colofnature[_100_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
