Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching values in 2 columns
I have 2 spreadsheets with various column. I would like to see if it's
possible tos et up a formula that will: 1. Look at each number in a specified column in sheet 1. 2. Attempt to find that same value somewhere in a specified column in sheet 2 3. If it doesn't find that number in sheet 2, it woud either highlight the value in sheet 2, or put a "no" in another column also in sheet 1. 4. Repeat this for each number in sheet 1. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Most Recent Values in Col1 -- Summing Matching Values | Excel Discussion (Misc queries) | |||
Matching values in two columns | Excel Discussion (Misc queries) | |||
matching values in columns that contain duplicates | Excel Discussion (Misc queries) | |||
Req help matching values across columns in Excel | Excel Worksheet Functions | |||
Matching values from two columns and making a third column with the results - possible? | Excel Discussion (Misc queries) |