| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup to bring in not true data.
Hi,
I need to create an if statement or vlookup that will compare both columns and bring back the results that is not true. I know what matches so basically I want to see all the data that doesn't match. I want to see the results of everything in Account II that doesn't match Account. Help everything I try doesn't work. Sarita aka non excel expert!!! Account Account II 154623 154142 154632 154189 154639 154632 154649 154636 154861 154739 154996 154840 155765 154850 155008 155765 155801 155829 159002 160632 160932 160934 166243 166249 166311 166448 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use vlookup to bring back data from second occurrence of the value | Excel Worksheet Functions | |||
| Vlookup, Bring up certain Info. only??? | Excel Discussion (Misc queries) | |||
| Vlookup, Can I only have it bring up a transactions once? | Excel Discussion (Misc queries) | |||
| How to vlookup and bring over fill colors as along with the data | Excel Worksheet Functions | |||
| Can you use a vlookup to bring in a picture? | Excel Discussion (Misc queries) | |||
Threaded Mode
